MS Access Question: how to count a record created today

Unable to open your database at the moment.

This depends on how your date field is entered.  If you use the Date() function to store the date value then you can simply use a query criteria  that looks like:

WHERE [DateField] = #11/25/2019#

Select allOpen in new window

or

WHERE [DateField] = Date()

Select allOpen in new window

If, however, you use the Now() function to fill in the date field, then you need to either convert that value to a date only, or use a date range.

WHERE DateValue([DateField]) = Date()

Select allOpen in new window

or

WHERE [DateField] >= Date() AND [DateField] < DateAdd("d", 1, Date())

Select allOpen in new window