Daily Report

  • Thread starter Thread starter tulikapuri
  • Start date Start date
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.
 
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...
 
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."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating a form in Microsoft office 1
Access 2010 Report Button 0
check boxes for days of the week 7
Excel Barcoding using a central database repositories 0
How NOT to update 1
Access Access Report 0
Excel In Excel how can I save a value on daily basis 2
{Q} How to modify record in M Access database? 0

Back
Top