Between dates criteria

  • Thread starter Thread starter flyfree
  • Start date Start date
F

flyfree

Access 2000. If I put a specific date, or a date <, in one column criteria it
is OK, but if I put crieria in two columns it only shows some of the data or
none at all. I have been unable to get any information up if I put > and <
dates.
 
Since you have just one date field use the criteria:

Between 1/1/2008 and 31/12/2008

GeorgeCY


Ο χÏήστης "flyfree" έγγÏαψε:
 
Access 2000. If I put a specific date, or a date <, in one column criteria it
is OK, but if I put crieria in two columns it only shows some of the data or
none at all. I have been unable to get any information up if I put > and <
dates.
Click to expand...

Please open your query (with the two criteria) in SQL view and post it here.
It may help to post an example of a record which should be retrieved and
isn't.
 
Back
Top