Access 2000 Database Query

  • Thread starter Thread starter John Foitzik
  • Start date Start date
J

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
 
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#
 
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.
 
Back
Top