Prev: using dates Part 2
Next: Troubleshoot A Query
From: Duane Hookom on 26 Mar 2010 15:06
I surprised it gets even that far without a SELECT statement.

If you have an issue with a query, it is customary to post all the SQL.

--
Duane Hookom
Microsoft Access MVP


"GWB" wrote:

> OK - I guess the brackets are the problem.... it work now, but asks for the
> start time and stop time twice! Thanks for any help
>
> "GWB" wrote:
>
> > I'm trying to retrieve records with a start date and stop date criteria. The
> > format of the Date column in my table is general date.
> > I dont understand why it wont work
> >
> >
> > FROM [Spreadcheck on this laptop]
> > WHERE (((([Spreadcheck on this laptop].Date)>=[Start Date] AND [Spreadcheck
> > on this laptop].Date)<[Stop Date]));
> >
 | 
Pages: 1
Prev: using dates Part 2
Next: Troubleshoot A Query