Queries

SQL WHERE = Query Results
This is in conjunction with my previous thread. I'll try and simplify my request. How do I write this SQL: " WHERE [Department #] = .... The values from [DeptQry]![Department #]? Thank you in advance -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200... 8 Jul 2008 07:58

follow-up
I have also tried creating it as a nested iif, would this make it easier to solve my problem (and only prompt, or open a form when it is necessary)? Sorry for my simplistic response, I am still a bit of a novice when it comes to Access... IIf(Analyst!Q2FY08Split>0,Analyst!Q2FY08Split,IIf(Analyst!Q2FY09Spl... 7 Jul 2008 15:36

No Value returning from query
I have a query that sums a particular field as part of the query. Sometimes there is not any data to sum and so no value is returned in the sum line. Is there a way to return a zero (0) value in these instances? Thanks for your help. Brennan ... 7 Jul 2008 19:43

"Record Deleted"
None of those things. It was an unrelated piece of database software that uses an entirely different program (sequel worksheet) as its base. Copying it didn't help at all. Fortunately, it solved itself. It went away again in 2 days, for no reason whatsoever. I'll have to chalk it up to network connectivity... 7 Jul 2008 14:33

Using prompts in a switch statement.
Hello, I have setup a switch statement, with the final item, if true, requesting the database user to input a value. I was curious if it is possible to make the query run so that it only prompts for a value if the final statment ([Analyst]![Fy06Split]+[Analyst]![FY07Split])>0) is true. Due to the setup of the... 7 Jul 2008 15:36

Limit Rows returned in a query
Is there any way to limit the number of rows returned in a query, I have some conditions but I only want the first 5 rows returned ... 7 Jul 2008 14:33

rst loop versus For Each
I'd like to use the values from rst (DeptQry) instead of the items selected. Here is my current code for the items selected. Please let me know how to change it from the items selected to DeptQry results. Thank you in advance. Dim strSQL As String Dim varItem As Variant Dim frm As Form, ctl As Control Set frm... 23 Jul 2008 16:24

Month date offset query
I have a table that contains: Project, Phase, StartDate, Month1, Month2, Month3,...Month48 Ecah Month column contains the number of hours spent in that month on the project. The Month columns are not dates. I am trying to query the projects so that I can align all of the columns of hours based on the curr... 23 Jul 2008 16:24

Updating and Erasing Data
Hi Everyone; It's hard to explain what I need... I have a table. Everyday for once new data is getting stored in it. These latest datas should be transferred and added over values in another table which comes from earlier dates. Because one customer can have some other entries in earlier days. After these add... 7 Jul 2008 14:33

Excel and filter
Hi I have a problem regarding transfering data from a query to excel. The problem is that I need it to be filtered before transfering so it is only the requested data that are being transferred. At the moment the users have a form where they can choose to open an report or a data report. But they should als... 7 Jul 2008 11:28