Summing on report from separate queries

J

jk

Hi,

I would like to have my report have the sum totals from two differrent
queries.Is this possible and if it is, what are the steps involved in getting
these results?

Thanks
 
D

Duane Hookom

You can create an unbound report with a text box and control source of:
=DSum("FldA","TableA") + DSum("FldB","TableB")
If you need multiple fields or multiple records, you will have to provide a
few more details.
 
J

jk

Thanks Duane,

Actually it is two select queries that i want the sums for.I have the
following:
invoice table Product table
invoice num item size
item code item color
item amt item name

There is a code for every item in the product table.I have a select query
that has a criteria from the invoice table that selects only item amts under
100 dollars and gives me the sum.Then i have another query that select
through parameter from the product table [ enter item name]...the name can be
shoes or ties.Anything entered into the parameter is selected and i get a sum
for that as well.These are two separate querys.Qryund100 and QryProname...how
do you join these two for one report that shows each total?
 
J

jk

Sorry Duane,
I meant to say, i already have a grand total for one report using one
query.All i really need is to have a second grand total added from the other
query(One report that shows two grand totals from two separate querys.
 
D

Duane Hookom

Again, you can use DSum() to get a total from another query. Other options
are:
-Code that opens a recordset and retrieves a value
-Combo Boxes have Row Sources which can be the other query
-Subreports have their own record source
 
Top