Daily Report

T

tulikapuri

Can someone please guide me how can i make daily report in access , i
am having
more than 13 records per day and i want the report for each day the
next morning.
 
A

Al Campagna

Can someone please guide me how can i make daily report in access , i
am having
more than 13 records per day and i want the report for each day the
next morning.
Click to expand...
 
A

Al Campagna

Sorry about the previous blank reply... a finger check.

Each record should have a date field, ex. CreateDate (never name a a date field "Date")
In the query behind your report, a criteria against CreateDate of...
= Date() - 1
will only return records with the previous day's CreateDate.

Or... in a more correct syntax...
= DateAdd("d",-1,Date())
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top