I am trying to query a PeopleSoft database through ODBC using microsoft access and retrieve values specific to the current date. The table I am querying has a date field, but it contains data/time information. I have tried using the Date() function in the criteria, but it rejects it because the table contains date/time values. An example of the data in the table is: 4/4/2007 1:03:25 AM
Of course if I use Now() it pulls in the current system time so it bombs too. Is there any other criteria I can specify to get the record data for the current date only??