I have a simple program in access2007 the table name is tblDTS, and field names are subject, status and tbldate and its query name is admrec, in design view of query admrec, how can i filter the records which date is current date in the criteria? For example i have a records which date are 07/14/2011,07/15/2011,08/15/2011,08/16/2011,08/16/2011
For example the date today is 08/16/2011
I want that when i open the query admrec in datasheet view, the records that contains only the current date will be shown.