I want to create a query that will give me all records from a certain date. The table being queried stores the date/time in general format, which includes both date and time.
When I enter query criteria to filter the date I get no records. For example, if I put in 4/26/2012 as the criteria, I get no records. I'm assuming it's because I haven't matched
the whole field.
How can I enter criteria in the query to get the all records from the table on a given date?