I have a date field which has a default value of =Now() so that the user does not have to input this value during data entry. However, when I do a query for this date field, it does not show any of the data related to the date. One thing is, if I enter the date field manually, the query works...