Between dates criteria

[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.

 

[George]

Since you have just one date field use the criteria:

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

GeorgeCY


Ο χÏήστης "flyfree" έγγÏαψε:

 

[John W. Vinson]

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.

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.