Re: drw date problem

This should help:

http://support.microsoft.com/defaul...&Product=fp2002


"Hayden Greg" <HaydenGreg@discussions.microsoft.com> wrote in message
news:E63CE5DD-4496-4A7E-B022-7546BFC8B4EF@microsoft.com...
> Using DRW and Access I created a search page that will not work when I add
the date as the search criteria. The access field is set up as a short date
7/20/2004. Using DRW I tried a custom query
>
> SELECT * FROM LAB
> WHERE (DATE = ::date:
>
> On my search page when I place a date in my search field I get
> No Records Returned
>
> So, then I tried it without a custom query. In DRW I tried adding criteria
under more options ( date = date). I got the following error when putting in
a date on my search page.
> Data type mismatch in criteria expression.
> Number: -2147217913 (0x80040E07)
> Source: Microsoft JET Database Engine
>
> I would also like to create a search where you can put in a range of dates
that looks at one field in access.
>
>