Querie Help

[nightmaregenerator]

I have 20 or something queries that continues to grow, as every time a new driver is employed I need to do a new run sheet which is handled by the query and put into a report.

But because these run sheets are done weekly I need a way to update this growing list of queries very quickly and efficiently.

I was thinking of an Update query, but I'm only new to using Access 2007 and have jumped into the deep end.

Would an Update query work or would I need something else?

 

[pbaldy]

Why do you keep adding queries? If you have one for each driver, then you should have one parameter query that works for all of them.

 

[nightmaregenerator]

So I would just have all the fields I need and have the paramenters asking:
Like [Which Last Name?]
Like [Which First Name?]
Between [Type the beginning date:] And [Type the ending date:]

 

[pbaldy]

That, or enter parameters in a form and have the query look there. You definitely don't want a query per driver, or anything like that.

 

[nightmaregenerator]

I have attempted to make a form to enter the parameter values, but with the query that I need to run, does it need all the fields? Or just the three that want to search?

With this said with a parameter query that has
First Name, Last Name, Start Week, and End Week, how do I get it to search for records that fall between the two dates?

 

[jdraw]

I have attempted to make a form to enter the parameter values, but with the query that I need to run, does it need all the fields? Or just the three that want to search?

With this said with a parameter query that has
First Name, Last Name, Start Week, and End Week, how do I get it to search for records that fall between the two dates?

Here's a tutorial ( in fact there is a follow on tutorial to this one) at
http://www.fontstuff.com/access/acctut17.htm
that has info that may help

 

[nightmaregenerator]

I found a similar page and tried implementing a Parameter Query, but when ever I hit run it tells me that:

This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)

When I type any value. Including names and dates.

 

[jdraw]

I found a similar page and tried implementing a Parameter Query, but when ever I hit run it tells me that:


When I type date values in. Even though I type them like this 01/01/2010.

You may have to type dates in like this #01/01/2010#

Also, did you look at the idea of a form presented to the user, in which he can make some selections from combo boxes, and behind the scenes (vba), you can create the associated SQL for your query. In effect, you left the use make selections on a preliminary form. These selections are used to create the appropriate query to get you the proper data.

The approach is in the tutorial I mentioned.

There is also a tutorial on Parameter queries.
http://www.fontstuff.com/access/acctut01.htm

 

[nightmaregenerator]

I did try to use a form but I had another error come up which was
Enter Parameter:
[Forms]![QueryRequest]![txtFirstName]
and that would continue for the fields I had put that reference into.