Query returns no records

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a query that prompts user for a date.....the
problem is it will never return any records. The source
is another query. What could cause this phenomenon?
 
Couple of possibilities:

The records have a field whose values were filled by the "Now()" function,
not the "Date()" function....thus, the values contain time other than "12
midnight", and won't usually match a date-only value.

Your query isn't properly delimiting the date that is entered, and the query
doesn't recognize the entered value as a date. You must delimit dates with #
character.

To give more specific info, you'll need to post more info about the
table/field setup, how the values were entered, and the SQL statement of the
query.
 
Back
Top