I have used the criteria Date() to get results for items logged today in a query in other databases with no problems but I am using a database now and cannot get this to work in a simple query. An error Undefined function 'date' in expression comes up. The field I am using it on is a date/time field called Date. I tried renaming the field date opened but it still won't work. Any ideas??