How do I search between two dates in an access parameter query?

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

Guest

I'm trying to set up a parameter query which displays training courses
between 2 dates - so a financial year for example - but when i type in 2
dates that aren't in the same year, it displays all records or a selection
that wasn't in the query I ran. the criteria I am using is Between [enter
first date And [enter last date] - does anyone have any idea what I am doing
wrong?
 
I'm trying to set up a parameter query which displays training courses
between 2 dates - so a financial year for example - but when i type in 2
dates that aren't in the same year, it displays all records or a selection
that wasn't in the query I ran. the criteria I am using is Between [enter
first date And [enter last date] - does anyone have any idea what I am doing
wrong?
Click to expand...

No, because we do not know what's stored in your table, nor what
you're entering in response to the prompts.

One suggestion: right mouseclick the grey background of the query grid
(between the table icons) and select Parameters. Copy and paste the
EXACT paramters you're using - e.g. [enter first date] - with the
brackets into the left column and specify Date/Time in the right.

John W. Vinson[MVP]
 
Back
Top