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

Posted on 2011-05-06
Last Modified: 2012-05-11
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?
Question by:Anthony6890
    LVL 84

    Accepted Solution

    Use DateAdd:

    Format(DateAdd("m", 1, DLookUp("[SPEC]","[RUNDTE]","[SET]=1")), "mmmm yyyy")
    LVL 119

    Assisted Solution

    by:Rey Obrero
    try this

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

    Author Comment


    It worked like a charm.  

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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now