Not finding records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jema@5linx.net - 26 Feb 2004 18:11 GMT

I have a database where I created a query-by-form form.
Everything works fine with the form, except the field
StartDate. It does not find any records, even though, I
know there are records it should retrieve

I enter 01/01/2000 and it comes with no records to
retrieve. Same for 01/01/00. I happen to have another
field called EndDate and it works fine. I do not know
what I did or did not do for this field, to make it act
like that. Changing the format did not do anything. Any
ideas or suggestions? Thanks a lot.

Reply to this Message

chris - 26 Feb 2004 23:06 GMT

If the data in your StartDate column contains a non zero
time component you will not get a match. Formatting the
column to show date only does not change the actual data
in the column, nor does it change the filtering comparison

>-----Original Message-----
>I have a database where I created a query-by-form form.
[quoted text clipped - 10 lines]
>
>.

Reply to this Message