Expression Builder Criteria

  • Thread starter Thread starter Jaz
  • Start date Start date
J

Jaz

I have a query that has a date field. How would I write the expression if I
wanted the criteria to be between 2 dates?

For example, I want the query to select only the records that are between
1/13/06 to 2/26/06?

Thanks,
Jasper
 
I have a query that has a date field. How would I write the expression if I
wanted the criteria to be between 2 dates?

For example, I want the query to select only the records that are between
1/13/06 to 2/26/06?

Thanks,
Jasper
Click to expand...

If you wish to hard code the dates, then:
Between #1/13/06# and #2/26/06#

If you wish to allow the user the enter the dates as wanted, then:
Between [Enter Start Date] and [Enter End Date]

The user will then be prompted to enter the dates.
 
Back
Top