|
| 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
March 24th, 2008, 06:46 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Use response to prompt in a report
I have a query which prompts for a date range. I would like to be able to
save the user's response and use the range in the title of a report. Is this possible? 
|
|
#2
March 24th, 2008, 08:05 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Use response to prompt in a report
How do I refer to the parameter? My prompt is written as =[From?
(MM/DD/YYYY)] AND = [TO? (MM/DD/YYYY)] "Marshall Barton" wrote: lfcjr wrote: I have a query which prompts for a date range. I would like to be able to save the user's response and use the range in the title of a report. Is this possible? Saving it is not really viable. OTOH, you can easily display it in a report text box just by referring to the parameter as if it were a field in the query. -- Marsh MVP [MS Access]
|
|
#3
March 24th, 2008, 08:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Use response to prompt in a report
lfcjr wrote:
I have a query which prompts for a date range. I would like to be able to save the user's response and use the range in the title of a report. Is this possible? Saving it is not really viable. OTOH, you can easily display it in a report text box just by referring to the parameter as if it were a field in the query. -- Marsh MVP [MS Access]
|
|
#4
March 25th, 2008, 12:58 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Use response to prompt in a report
That's actually two prompts.
You could use a text box expression like: ="Between " & [From? (MM/DD/YYYY)] & " And " & [TO? (MM/DD/YYYY)] Use Copy/Paste from the query to the expression to make sure the above expression has the **exact** same strings as the query. -- Marsh MVP [MS Access] lfcjr wrote: How do I refer to the parameter? My prompt is written as =[From? (MM/DD/YYYY)] AND = [TO? (MM/DD/YYYY)] "Marshall Barton" wrote: Saving it is not really viable. OTOH, you can easily display it in a report text box just by referring to the parameter as if it were a field in the query. lfcjr wrote: I have a query which prompts for a date range. I would like to be able to save the user's response and use the range in the title of a report. Is this possible?
|
|
#5
March 25th, 2008, 11:39 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Use response to prompt in a report
Thanks, Marshall.
"Marshall Barton" wrote: That's actually two prompts. You could use a text box expression like: ="Between " & [From? (MM/DD/YYYY)] & " And " & [TO? (MM/DD/YYYY)] Use Copy/Paste from the query to the expression to make sure the above expression has the **exact** same strings as the query. -- Marsh MVP [MS Access] lfcjr wrote: How do I refer to the parameter? My prompt is written as =[From? (MM/DD/YYYY)] AND = [TO? (MM/DD/YYYY)] "Marshall Barton" wrote: Saving it is not really viable. OTOH, you can easily display it in a report text box just by referring to the parameter as if it were a field in the query. lfcjr wrote: I have a query which prompts for a date range. I would like to be able to save the user's response and use the range in the title of a report. Is this possible?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
