Access 2003

[Jacob]

Ok, I am having troubles...I am using this as a critiera in a query in the
field DateSold...

<=CVDate([Enter date]) OR Is Null


When I enter a date, it does bring back my null values like it should, but
when I enter a date, it still pulls dates from beyound what I enter (Greater
than)...Any ideas what is causing this?

My table field for DateSold is set as TEXT and SHORT date with a input
mask of 99/99/0000;0;_

I also tried it as a date field with the same input mask.


Thank you in advance for any guidance.


Jacob

 

[John Smith]

If your date field is text then your criteria will return all dates that are
alphabetically earlier - not generally very meaningful!

1/April
19/Apr
2/Apr
25/Apr
3/Apr
1/August
1/February
etc...

You must put your date into a date column to be useful but I would advise not
having an input mask on it, it will make life more difficult for the users
rather than easier. The format and input masks have no effect on querying the
data, only on displaying/inputting it.

John
##################################
Don't Print - Save trees