> You might need to use # around the date as well as in:
That worked :-) What on earth is Microsoft thinking with #'s?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
- [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Scott Cree
- RE: [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Scott Cree
- Re: [DUG-DB]: Dates in SQL/Access Tony Blomfield
- Re: [DUG-DB]: Dates in SQL/Access BJ Wilson
- RE: [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Patrick Dunford
- RE: [DUG-DB]: Dates in SQL/Access Mark Derricutt
- RE: [DUG-DB]: Dates in SQL/Access Derricutt, Mark
- RE: [DUG-DB]: Dates in SQL/Access Grant Black
- Re: [DUG-DB]: Dates in SQL/Access Tony Blomfield
- Re: [DUG-DB]: Dates in SQL/Access Mark Derricutt
- Re: [DUG-DB]: Dates in SQL/Access Tony Blomfield
