HELP - I hate ACCESS

[Toyotagrl]

I have just recently started training on this grumpy program. All I want to do is make my query prompt for a date
I am running a query for each group, for each month...
Like Assembly for the month of July - I have tried the whole [start date] [end date] thing and nothing comes up... what am I doing so wrong?

Thanks...

 

[Ally]

Try putting: Between [Enter Start Date] And [Enter End Date].

 

[thouston]

When you say "nothing comes up" do you mean the query fails or that it doesn't give you any results?

If the second, check that the start and end dates for your query actually include some of the data from your database. If this isn't the problem, check that you are inputting the criteria dates in the same format as they are in the table.

Otherwise, give some more details of what your query looks like and the data types involved & I'll try to help more!

 

[Cosmos75]

Are you trying to have your query return records with the criteria that one field (some kind of date) is between StartDate and EndDate?

Am attaching a simple database with a query that is base on a table with two fields , DateValue and Value. The query will prompt the user to enter StartDate and EndDate.
This is done by putting in the Criteria (in the query design view) Between [StartDate] and [EndDate].

I didn't name the field in the table Date because that's a reserved word in VBA and should be avoided in naming fields.

If this isn't what your problem is, post back and I'll try to help!

 

[Toyotagrl]

THANK YOU THANK YOU THANK YOU
THE BETWEEN WORKED WONDERFULLY... YOU GUYS ROCK!!!

 

[Cosmos75]

Includes or excludes Start and End dates?

Glad to be of help!

A few words of caution:
You may want to check to see if includes the Start and End dates in your query.

I can't remember if it only includes the date in bewteen excluding the start and end date or if the start and end date is included...

What kind of Toyota do you drive, Toyotagrl?