Help with date query

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

Guest

I am using Access 2000 and have a database that collects information with a
date stamp (mm/dd/yyyy). I set up a query to collect records based on a start
date and an end date. My criteria are >[start date] And <[end date]. However
when I run the query, I get no results even though there are records that are
between the start and end dates I entered. What am I doing wrong?
 
It could be that the query engine is misunderstanding the parameter. It may
see (11/13/2005) as 11divided by 13 divided by 2005 and then interpret that
as a datetime on December 30 1899.

Try one of the following fixes

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

Or force the parameters to be type cast using CDate
CDate([Start date]) and <CDate([End Date])
Click to expand...


DOOGIE said:
I am using Access 2000 and have a database that collects information with a
date stamp (mm/dd/yyyy). I set up a query to collect records based on a
start
date and an end date. My criteria are >[start date] And <[end date].
However
when I run the query, I get no results even though there are records that
are
between the start and end dates I entered. What am I doing wrong?
Click to expand...
 
Back
Top