Not finding records

[jema]

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.

 

[chris]

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