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?
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Use DateAdd:

Format(DateAdd("m", 1, DLookUp("[SPEC]","[RUNDTE]","[SET]=1")), "mmmm yyyy")
Rey Obrero (Capricorn1)Connect With a Mentor 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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.