Query question

[Guest]

I ran a query based on deliveries made on and after 6/1/2007. In my
criteria, I typed >#6/1/07#. When I hit execute, it pulls all the files.
What do I do? It is not giving me an error message but it is giving what I
asked for.

 

[Guest]

Let me see if I understand you correctly...
when you run the query, it's giving you ALL the results in the table, not
the ones for anything greater than 6/1/2007?

If that's the case, try replacing >#6/1/07# with >6/01/2007
(make sure that your format in the table is correct, if it's supposed to be
6/01/2007, you're query needs to be the same format)

 

[Jeff Boyce]

Everything starts with the data in Access.

Since we don't know anything about your data, maybe all your records'
date-criterion fall after June 1, 2007.

Or maybe your PC (or your date data) is set to non-USA date standard
(?dd/mm/yyyy).

Since we don't know anything about how you are querying (no SQL statement),
maybe there are other criteria in play.

More specific descriptions may lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pieter Wijnen]

The safest IMnsHO is to use military format #2007-06-01#

Pieter

 

[Guest]

Thank you for the suggestion. I will remember that for the next time.

 

[Guest]

Thanks that actually worked. All I needed to do was put a 0 in front of the
6. Access is very tedious.