Link to home
Start Free TrialLog in
Avatar of Hiro 714
Hiro 714

asked on

MS Access Question: how to count a record created today

I would like to count today's created record on MS Access
Database5.accdb
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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#

Open in new window

or
WHERE [DateField] = Date()

Open 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()

Open in new window

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

Open in new window