Access and Dates

  • Thread starter Thread starter Tina Korncavage
  • Start date Start date
T

Tina Korncavage

Hi Everyone,

What i'm trying to do is create a Query using a specific
time period from the data that I have. For some reason I
can't come up with the expression that I need.. i.e. i
need to just take the data from 05012003 to 05312004 and
create reports... can anyone help!?!?!???!
 
Hi Everyone,

What i'm trying to do is create a Query using a specific
time period from the data that I have. For some reason I
can't come up with the expression that I need.. i.e. i
need to just take the data from 05012003 to 05312004 and
create reports... can anyone help!?!?!???!
Click to expand...

If you wish to hard code the dates, then, as criteria in the Date
Field column:
Between #5/1/2003# and #5/31/2004#

If you would like the user to be prompted to enter the date range,
then:
Between [Enter Start Date] and [Enter End Date]
 
Tina,

The expression you are looking for is follows:

[Date] >= [From Date] and [Date] <= [To Date]

If you don't have a table where you are pulling the from date or to date from this format will also prompt the user for this information.

If you need any additional help let me know

Thank you,
Kevin McBrearty
 
Back
Top