how do I use a date when working with a query within Access

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

Guest

Hi All

I am trying to create a query in Access using a date i.e select all workers
who have a start date before 01/08/01. Can anyone suggest how to enter this
simple query?

ND
 
ND said:
Hi All

I am trying to create a query in Access using a date i.e select all
workers who have a start date before 01/08/01. Can anyone suggest
how to enter this simple query?
Click to expand...

use #01/08/01#
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Count dates within a Month 4
Using DateAdd and IIF conditions in a Query 2
Date search query 0
Stored date is not being recognised 1
Date Range Query. Criteria based in a table. 4
Query By Date and Count Records 3
Smart Filter For My Query 1
Using Date parameters in select queries Access 2003 5

Back
Top