Access 2000 Database Query

[John Foitzik]

In a library database I have to search for all chemistry
books acquired between 1970 and 1980. The chemistry part
is no problem. However, on using the "between" symbol in
the criteria row I get nothing but greyed out headings in
database view without any data page at all. What could be
going on?

I would be most grateful of any help

 

[Ken Snell]

Post the SQL statement that you're trying to use.

In general, the criterion would look something like this:

Between #1/1/1970# And #12/31/1980#

 

[tom]

Access expects dates in US format - mm/dd/yyyy and doesn't look at whatever
your regional setting are...Therefore try this:

BETWEEN FORMAT(#01/01/1970#, 'dd/mm/yyyy') AND
FORMAT(#31/12/1980#,'dd/mm/yyyy')

HTH.

Tom.