I have a datetime field in a table stored in Sql Server. I haev a access query that I am trying to allow a user to input a date and select all the records that correspond to that date.
=[Beginning Date: 'mm/dd/yyyy']
The problem is that the date the user types in is:
06/24/2010
But the date in the database has:
06/24/2010 10:24:00:00
So no records return.
There has to be an easy way to query anything with just the date portion matching regardless of the time???
Thanks for your help.....