SQL Syntax Help

[kmattera]

I am trying to figure out the proper Syntax for displaying a listing of dates that include today's date up to a certain date range. For example, I want to display any item that is between September 1 - September 30, 2006, but ONLY list anything current, nothing prior to today's date. make sense?

Here's what I've tried, but its not working.. .

SELECT Events.ID, Events.Event_Name, Events.Date, Events.Description, FROM Events WHERE Events.Date >= #"& date() &"# AND Between #09/01/2006# And #10/01/2006# ORDER BY Events.Date ASC

 

[PHV]

SELECT ID, Event_Name, [Date], Description
FROM Events
WHERE [Date] Between Date() And #2006-09-30#
ORDER BY 3

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886