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
Database5.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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:
Open in new window
orOpen 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.Open in new window
orOpen in new window