prompt user input for report

[mark r]

I have a query1 that pulls order date and sale amount
I have a different query2 that sums sale amount group by
order date.
I have a report1 that uses query 1 as a source
I have a reprt2 that has query 2 as a source
I thought I could put a subreport in report 1 that uses
reprt2 as a source
then I would have the details and the sum all on the
same report.

I put in two criterias in the queries

[whatorderdate] in query 1 whihc pares down the detail in
report one to 6 records on a report date of 11/03/2002

[whatorderdateagain] into query2 which sums sales amount
for 11/03/2002

Now it appears to me that when I run the report, I am
first prompted for [whatorderdate] and I type 11/03/2002
then I get prompted for [whatorderdateagain] six times
and then the report runs and yes I see the detail and the
sum total.

how do I prevent ACCESS from prompting me six times, one
for each detail record in query/report 1? I would rather
pass on the first prompt automatically to the second since
they would be for the same date.

perhaps a user definition response to the wizard when I
create the sub report rather than the wizard response "for
each order date"

 

[Duane Hookom]

You should create a form with a text box for the user to enter a date.
Replace your criteria prompt with:
Forms!frmYourForm!txtDate
If you report only ever reports for one date, you could probably set the
Link Master Child properties to the date field.

 

[mark r]

great idea, then I have a command button that launches the
report - am I correct - please respond

-----Original Message-----
You should create a form with a text box for the user to enter a date.
Replace your criteria prompt with:
Forms!frmYourForm!txtDate
If you report only ever reports for one date, you could probably set the
Link Master Child properties to the date field.

--
Duane Hookom
MS Access MVP

I have a query1 that pulls order date and sale amount
I have a different query2 that sums sale amount group by
order date.
I have a report1 that uses query 1 as a source
I have a reprt2 that has query 2 as a source
I thought I could put a subreport in report 1 that uses
reprt2 as a source
then I would have the details and the sum all on the
same report.

I put in two criterias in the queries

[whatorderdate] in query 1 whihc pares down the detail in
report one to 6 records on a report date of 11/03/2002

[whatorderdateagain] into query2 which sums sales amount
for 11/03/2002

Now it appears to me that when I run the report, I am
first prompted for [whatorderdate] and I type 11/03/2002
then I get prompted for [whatorderdateagain] six times
and then the report runs and yes I see the detail and the
sum total.

how do I prevent ACCESS from prompting me six times, one
for each detail record in query/report 1? I would rather
pass on the first prompt automatically to the second since
they would be for the same date.

perhaps a user definition response to the wizard when I
create the sub report rather than the wizard response "for
each order date"

.

 

[Duane Hookom]

Yes, a command button would be appropriate.

--
Duane Hookom
MS Access MVP

great idea, then I have a command button that launches the
report - am I correct - please respond

-----Original Message-----
You should create a form with a text box for the user to enter a date.
Replace your criteria prompt with:
Forms!frmYourForm!txtDate
If you report only ever reports for one date, you could probably set the
Link Master Child properties to the date field.

--
Duane Hookom
MS Access MVP

I have a query1 that pulls order date and sale amount
I have a different query2 that sums sale amount group by
order date.
I have a report1 that uses query 1 as a source
I have a reprt2 that has query 2 as a source
I thought I could put a subreport in report 1 that uses
reprt2 as a source
then I would have the details and the sum all on the
same report.

I put in two criterias in the queries

[whatorderdate] in query 1 whihc pares down the detail in
report one to 6 records on a report date of 11/03/2002

[whatorderdateagain] into query2 which sums sales amount
for 11/03/2002

Now it appears to me that when I run the report, I am
first prompted for [whatorderdate] and I type 11/03/2002
then I get prompted for [whatorderdateagain] six times
and then the report runs and yes I see the detail and the
sum total.

how do I prevent ACCESS from prompting me six times, one
for each detail record in query/report 1? I would rather
pass on the first prompt automatically to the second since
they would be for the same date.

perhaps a user definition response to the wizard when I
create the sub report rather than the wizard response "for
each order date"

.