get a total on a report

M

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.
it does not work.
 
D

Duane Hookom

Reports with subreports generally work. Can you provide a little more
information regarding your statement "it does not work"?
I expect that you might have the Link Master/Child properties set.
 
M

mark r

I see labels of the sub report show up including footer Now
() but the summed up data fields of sales amount and
[group by] date themselves do not appear
 
M

mark r

I learned something from what you wrote, so I made some
changes.

I pu tin two criterias.
[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"
 
Top