Date Range in Header

L

lburgoyne

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.
 
J

John Spencer

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
 

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

Date Range in Header 1
Date range in header 4
print a date range from parameter query on a report header? 2
Date Range in Reports 2
Parameter Query In Report Title 3
Include Date Range in header 3
Date Range in Report Header 1
Pulling date from parameter 2

Top