reports in VBA

N

NagaKiran

Hi

I am working on VBA reports.
I am able to generate reports based on database tables.
I want to generate last 7 days report.
Where can I specify this constraint?
How to generate the reports which has last 7 days
information?

thanks

bye
 
C

Chad DeMeyer

NagaKiran,

I assume that there is some date field in the database tables that you can
use for this. In that case, you should handle this in the SQL statement you
use to get a recordset to confine that recordset to records with a date
within the desired range.

Regards,
Chad
 

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

Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
How to automate update on weekly reports spreadsheet 0
How to have two tables on same line? 1
Show week number in Project Report 0
Grouping Names in Mail Merge 0
Countdown macro - display settings 2

Top