I an trying to get a query to work based on a table that contains records that are created each day. All I want is to count how many records and summarise by location for the current date, so I would have two columns, one with site and one with the record count for todays date. So far I have tried everything I can think of to get the date format to work and I get nothing. The date column is a Date / Time column and I want to compare to CurDate()

Any ideas of the syntax?

Thanks!