Date Range in Header

Discussion in 'Microsoft Access Reports' started by lburgoyne, Apr 6, 2010.

  1. lburgoyne

    lburgoyne Guest

    I have a report that is based on a query that is using text fields from a form as begin date and end date parameters.

    This all works well.

    What I am trying to do is put a date range in the header of the report to reflect the values in the underlying query. Any ideas?

    Lou Burgoyne
    Keeper of the odd jobs.

    ---
    frmsrcurl: http://msgroups.net/microsoft.public.access.reports/
     
    lburgoyne, Apr 6, 2010
    #1
    1. Advertisements

  2. lburgoyne

    John Spencer Guest

    You should be able to reference the controls on the form just as you reference
    them in the query.

    In a text control, set the source to
    =Forms!NameOfForm!NameOfControl

    You can use the format function to format the dates, so you might end up with

    = "FROM " & Format(Forms![MyParameterForm]![StartDate],"DD MMM YYYY") & " TO "
    & Format(Forms![MyParameterForm]![EndDate],"DD MMM YYYY")

    John Spencer
    Access MVP 2002-2005, 2007-2010
    The Hilltop Institute
    University of Maryland Baltimore County

    lburgoyne wrote:
    > I have a report that is based on a query that is using text fields from a form as begin date and end date parameters.
    >
    > This all works well.
    >
    > What I am trying to do is put a date range in the header of the report to reflect the values in the underlying query. Any ideas?
    >
    > Lou Burgoyne
    > Keeper of the odd jobs.
    >
    > ---
    > frmsrcurl: http://msgroups.net/microsoft.public.access.reports/
     
    John Spencer, Apr 6, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Anita Taylor

    Including Date Range Parameter in Page Header

    Anita Taylor, Mar 22, 2004, in forum: Microsoft Access Reports
    Replies:
    2
    Views:
    145
    Anita Taylor
    Mar 22, 2004
  2. Guest

    Re:Date Range from Query in Report Header

    Guest, Aug 18, 2005, in forum: Microsoft Access Reports
    Replies:
    5
    Views:
    221
    Guest
    Apr 5, 2006
  3. Guest

    Re:Date Range from Query in Report Header

    Guest, Oct 5, 2005, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    384
    Guest
    Oct 5, 2005
  4. FA

    Print Parameter Date range on Report Header

    FA, Feb 9, 2006, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    477
    fredg
    Feb 15, 2006
  5. Guest

    Include Date Range in header

    Guest, Apr 5, 2007, in forum: Microsoft Access Reports
    Replies:
    3
    Views:
    186
    Guest
    Apr 6, 2007
Loading...

Share This Page