Query

[Guest]

I am working in a Access DB and trying to make a query that display(runs)
database user, consumer name and date entered. My question as a unexperienced
access user, how do you enter in the criteria, or the "or" field to list
dates from 10/1/2004 and 2/20/2005? I remember sometihing like #between
10/1/2004# and #2/20/20053# end. Anybody know?

 

[JudithJubilee]

Hello there,

You are almost right. You don't need to add the # symbols
Acces does that for you and you don't need the "end".

between 10/01/2004 and 01/20/05

OR

=10/01/2004 and <=01/20/2005

Hope this helps

Judith

 

[JudithJubilee]

Hello there,

You are almost right. You don't need to add the # symbols
Acces does that for you and you don't need the "end".

between 10/01/2004 and 01/20/05

OR

=10/01/2004 and <=01/20/2005

Hope this helps

Judith