![]() |
|
|
#1
|
|||
|
|||
|
I have a report that is based on an underlying query.At the query level,I have defined parameters of date data type so that records to be displayed should fall between DateA and Date B.ie Between[Enter Date A:] And [Enter Date B:].How can I display these two parameter values on the report header???
|
|
#2
|
|||
|
|||
|
In your report (probably in the report header or in the page header) put an unbound textbox, with this as the ControlSource:
="Data for dates between " & Format([Enter Date A:], "mmmm d, yyyy") & " and " & Format([Enter Date B:], "mmmm d, yyyy") The key is to use the exact same name for the parameters. |
|
#3
|
|||
|
|||
|
Quote:
However, I have tried your solution but the output doesnt bound to the parameters entered.ie it shows records which are out of specified date range. I just cant figure out how would above expression is going to reflect the related Date control. |
|
#4
|
|||
|
|||
|
Please download the following file and see how I set up the report. It is a very simplistic example, but it illustrates the advice I gave you.
http://www.geocities.com/matthewspat...rums255946.zip |
|
#5
|
|||
|
|||
|
Thanks very much mathews.it is working fine!!!
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Enter Parameter Value | plesser | Access | 1 | 11-08-2008 07:27 AM |
| calculate difference of $$ than can display in the subtotals in a report | taniuca | Queries | 0 | 08-07-2008 05:02 PM |
| Counting Values at end of report minus certain records | Blake | Reports | 1 | 11-11-2006 05:00 PM |
| Date Parameter | shakira | Queries | 2 | 03-09-2006 09:55 AM |
| DISPLAY INPUT PARAMETERS ON THE REPORT | fadone | Forms | 1 | 12-09-2005 07:26 PM |