Print Previous Month on a Report

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

Guest

I need to print the previous month and current year on the page footer of my
report. I can get the current date to print using "=Date()" but what I need
is for the report I am printing today to show "January 2006" Is this doable
and if so how? Thanks in advance for your assistance.

TheIguana
 
One method that may work for you
=Format(DateAdd("m",-1,Date()),"mmmm yyyy")
 
Nevermind, I figured it out on my own. Well, after reading a few posts I did!
Always love it when I can solve my own issues!
 
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

Report - Don't print the page footer on the last page 6
How do I write the print date on data row? 4
Excel Vba to change displayed year automatically. 14
Pull Previous Month 5
Need to print Cover Sheet for report. 11
Outlook 2016 Calendar printing monthly view 0
Using Access 2003 convert numeric month to text for reports 2
Report prints extra page on one computer 3

Back
Top