criteria for database results page

  • Thread starter Thread starter debi
  • Start date Start date
D

debi

Please help
Will someone please tell me how to use dates as criteria
for the database results page. For instance
[beginning date] And [ending date]
I would like, for example, to search for all purchases
between 8/1/03 and 8/30/03
Thank you
 
Access (all versions):

SELECT * FROM purchases WHERE purchaseDate BETWEEN #8/1/03# AND #8/30/2003#

SQL Server and most other databases (including latest version of Access):

SELECT * FROM purchases WHERE purchaseDate BETWEEN '8/1/03' AND '8/30/2003'

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.
 
Back
Top