I have a table with a date field that I'm building a query for. It has dates in this format:
4/17/2009 10:40:03 AM
4/17/2009 1:25:37 PM
(m/dd/yyyy h:mm:ss AM/PM, I think)
I would like the query to ask for a date and have the query show all records from that date. However, because of the full date and time format of the field, I'm having trouble writing the appropriate parameter query.
Anyone have some input?
Thanks!
4/17/2009 10:40:03 AM
4/17/2009 1:25:37 PM
(m/dd/yyyy h:mm:ss AM/PM, I think)
I would like the query to ask for a date and have the query show all records from that date. However, because of the full date and time format of the field, I'm having trouble writing the appropriate parameter query.
Anyone have some input?
Thanks!