Open Report based on date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two reports that are used for mailing labels. Before May 1 of each
year, I want to use the current address report, and after May 1 I want to use
the permanent address report. How can I code a command button to
automatically check the system date and open the appropriate report?
 
use the month of the current date, if it smaller then 5 then one condition
else the second condition


If Month(Date()) < 5 then
Docmd.OpenReport "[current address report]"
Else
Docmd.OpenReport "[permanent address report]"
End If
 
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

avoid duplicates on label report? 5
Filter report based on continuous form 1
Dates for Reports 3
Change lblHeading.Caption of report based on which form's buttonclicked 5
Eliminating Dates based on a measure 1
Access Access Report Works on One Machine but not Another 3
printing report with date 3
Report based on form value 7

Back
Top