Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
Click to expand...

Hope this helps

Judith
 
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
Click to expand...

Hope this helps

Judith
 
Back
Top