|
| 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
December 14th, 2009, 11:29 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Printing Query Promt Parameters in a report
I have a QUERY in Access 2003 that promts the user for a START and END date.
Is there a way to display the inputed START and END date from the QUERY in a REPORT without having to retype it in the report? 
|
|
#2
December 14th, 2009, 11:45 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Printing Query Promt Parameters in a report
On Mon, 14 Dec 2009 15:29:01 -0800, vegman wrote:
I have a QUERY in Access 2003 that promts the user for a START and END date. Is there a way to display the inputed START and END date from the QUERY in a REPORT without having to retype it in the report? Let's assume the exact query prompt is [Start Date] and [End Date] Add an unbound text control to the Report Header. Set it's control source to: ="For Sales between " & [Start Date] & " and " & [End Date] The above text within the brackets must be identical to the bracketed text in the query. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
December 16th, 2009, 06:01 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Printing Query Promt Parameters in a report
Another way is to add them as a 'calculated' field. In design view grid
blank in FIELD row copy and paste parameter to look like this -- Parm1: [Start Date] Parm2: [End Date] or Pram1: "For Sales between " & [Start Date] & " and " & [End Date] Use Parm1 and Parm2 or the second Parm1 in your report. -- Build a little, test a little. "fredg" wrote: On Mon, 14 Dec 2009 15:29:01 -0800, vegman wrote: I have a QUERY in Access 2003 that promts the user for a START and END date. Is there a way to display the inputed START and END date from the QUERY in a REPORT without having to retype it in the report? Let's assume the exact query prompt is [Start Date] and [End Date] Add an unbound text control to the Report Header. Set it's control source to: ="For Sales between " & [Start Date] & " and " & [End Date] The above text within the brackets must be identical to the bracketed text in the query. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
