• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

How do I get the next month to show up in the report header of an access report?

I currently have this formula that outputs the month of the date that is in a specific field in a table.  Here is the formula:

=Format(DLookUp("[SPEC]","[RUNDTE]","[SET]=1"),"mmmm yyyy")

Basically my database prompts for a run date at the beginning, "RUNDTE".  In my current formula it will output the month and year on the report header.  I need it to report the next month.

So if my RUNDTE is 04/30/2011, I want the report header to show May 2011.

Can anyone help me with this?
2 Solutions
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Use DateAdd:

Format(DateAdd("m", 1, DLookUp("[SPEC]","[RUNDTE]","[SET]=1")), "mmmm yyyy")
Rey Obrero (Capricorn1)Commented:
try this

=Format(dateadd("m",1,DLookUp("[SPEC]","[RUNDTE]","[SET]=1")),"mmmm yyyy")
Anthony6890Author Commented:

It worked like a charm.  

I knew it was something simple, just couldn't put two and two together.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now