Please help with Query

Microsoft Office 2007 basic (license onl...
June 29, 2010 at 04:52:40
Specs: Windows XP
I have a field called Start Date and need a query to identify starters between 4th April 2010 and 4th July 2010

See More: Please help with Query

Report •

June 29, 2010 at 05:08:22
Select * From TableName where StartDate > #4 April 2010# and StateDate < #4 July 2010#"

The # tells the SQL parser to treat the characters between as a date.
Select * selects all fields in the table.

Or you could put the dates into date variable and use it like any other variable.

I cannot guarantee that this query will work as is. You may have to mess about with the punctuation a bit.


Report •

June 29, 2010 at 05:28:13
Thanks for that. It worked a treat.

Report •

Related Solutions

Ask Question