adding totals to columns and linking several queries into one repo

[Guest]

I have several queries containing sales data, and need to be printed into a
report. The results of my queries need to have totals for the sales, which
than needs to be compared with ea other. for example sales A, totalling $2
which is a xx% of the total sales (all types of sales). This then needs to be
able to print also in a report.

How do I do this?

 

[Joseph Meehan]

I have several queries containing sales data, and need to be printed
into a report. The results of my queries need to have totals for the
sales, which than needs to be compared with ea other. for example
sales A, totalling $2 which is a xx% of the total sales (all types of
sales). This then needs to be able to print also in a report.

How do I do this?

Normally you would do this in the report. You can do all of that kind
of computation in a report. It involves adding hidden controls in the data
area and references to those controls in the group footer areas. It is a
little complex to describe in a news group message, especially when I don't
know exactly what you need, but most books on Access cover this and the
Access help file also has instructions (search for "total")

 

[Guest]

I did try to create 1 report for my 4 queries through the wizzard feature,
but it just locks up after I defined my fields I want to have in the report.

 

[Joseph Meehan]

I did try to create 1 report for my 4 queries through the wizzard
feature, but it just locks up after I defined my fields I want to
have in the report. "Joseph Meehan" wrote:

Start with a very simple report and see what happens.