If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display criteria parameter in an Access 2002 report
How can I display the parameters I entered for a query in the report header
made from that query? I need to show the start and end dates I entered from the following criteria… Between [Enter start date of period where patient was first seen in Out-patients] And [Enter end date of period where patient was first seen in Out-patients] Any help would be much appreciated, Kind regards, -- Tony |
#2
|
|||
|
|||
Display criteria parameter in an Access 2002 report
Tony, should should be able to refer directly to these parameter names in
your report. For example, put this in the Control Source of a text box on the report: =[Enter start date of period where patient was first seen in Out-patients] An alternative approach is to use text boxes on a form instead of parameters in the query. Details: http://allenbrowne.com/casu-08.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Tony Hagger" wrote in message ... How can I display the parameters I entered for a query in the report header made from that query? I need to show the start and end dates I entered from the following criteria. Between [Enter start date of period where patient was first seen in Out-patients] And [Enter end date of period where patient was first seen in Out-patients] Any help would be much appreciated, Kind regards, -- Tony |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using a form with combo box to input criteria | Christina | Using Forms | 16 | February 3rd, 2006 08:47 PM |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
Display Parameter Qry Criteria in Report | Maureen | Setting Up & Running Reports | 3 | November 18th, 2004 05:39 AM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |