MS Access Question: how to count a record created today

HIROYUKI TAMURA
HIROYUKI TAMURA used Ask the Experts™
on
I would like to count today's created record on MS Access
Database5.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
Take a look at my attachment
Database5--1-.accdb
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial