Parameters at top of report

[Joan]

Hi,
I have built a summary report based on a query that has many nested queries
within it. I have set query parameters, [StartDate] and [EndDate]. In one
of the nested queries, I have set the criteria of [FinalSaleDate] to:
Between [StartDate] and [EndDate]. My final query which is used as the
record source of my report does not have the [FinalSaleDate] field in it
because of all the Sum and Count functions in this Total query. MS Access
asks for the [StartDate] and [EndDate] when the user attempts to open the
report. However, I would like to display these dates at the top of the
report and do not know what to use as the control source for these
textboxes. How do I refer to these parameters? I do not know the name of
MS Access parameter dialog forms.

Joan

 

[Duane Hookom]

You can add columns in your first query:
SDate:[StartDate]
EDate:[EndDate]
Then, include this columns in your next query and your report.

 

[Joan]

Duane,
Thanks for your reply. I added the columns you recommended to my first
query and then the next. This seems to work except then Access asks for
the StartDate twice and the EndDate twice. Is there a way to ensure that
the user only has to enter these dates once?

Joan

You can add columns in your first query:
SDate:[StartDate]
EDate:[EndDate]
Then, include this columns in your next query and your report.

--
Duane Hookom
MS Access MVP

Hi,
I have built a summary report based on a query that has many nested queries
within it. I have set query parameters, [StartDate] and [EndDate]. In one
of the nested queries, I have set the criteria of [FinalSaleDate] to:
Between [StartDate] and [EndDate]. My final query which is used as the
record source of my report does not have the [FinalSaleDate] field in it
because of all the Sum and Count functions in this Total query. MS Access
asks for the [StartDate] and [EndDate] when the user attempts to open the
report. However, I would like to display these dates at the top of the
report and do not know what to use as the control source for these
textboxes. How do I refer to these parameters? I do not know the name of
MS Access parameter dialog forms.

Joan

 

[Joan]

Duane,
Please disregard my earlier reply. I found that by deleting [StartDate] and
[EndDate] off of the Query Parameter form that Access will ask for
[StartDate] and [EndDate] only once. My queries and the report is now
working perfectly. Thank you so much for your help!

Joan

You can add columns in your first query:
SDate:[StartDate]
EDate:[EndDate]
Then, include this columns in your next query and your report.

--
Duane Hookom
MS Access MVP

Hi,
I have built a summary report based on a query that has many nested queries
within it. I have set query parameters, [StartDate] and [EndDate]. In one
of the nested queries, I have set the criteria of [FinalSaleDate] to:
Between [StartDate] and [EndDate]. My final query which is used as the
record source of my report does not have the [FinalSaleDate] field in it
because of all the Sum and Count functions in this Total query. MS Access
asks for the [StartDate] and [EndDate] when the user attempts to open the
report. However, I would like to display these dates at the top of the
report and do not know what to use as the control source for these
textboxes. How do I refer to these parameters? I do not know the name of
MS Access parameter dialog forms.

Joan