Re: dates

From: Tony Toews <ttoews_at_telusplanet.net>
Date: Thu, 03 Jun 1999 01:08:26 GMT
Message-ID: <3755c4ac.105893426_at_news.telusplanet.net>

"Silicon Knight" <SiliconKnight_at_hotmail.com> wrote:

>select * from table where initial_date < '01-Jan-99' and final_date >
>'01-Jan-99';

If in Access put #s around the date instead of '. For example: [Quoted] select * from table where initial_date < #01-Jan-99# and final_date #01-Jan-99#;

If not Access the look in the help for your particular environment. The ' delimiter is typically for text fields only.

Tony

---

Message posted to newsgroup and, if appropriate, emailed. Tony Toews, Independent Computer Consultant Microsoft Access Links, Hints, Tips & Accounting Systems at

   http://www.granite.ab.ca/accsmstr.htm VolStar http://www.volstar.com Manage hundreds or

   thousands of volunteers for special events. Received on Thu Jun 03 1999 - 03:08:26 CEST