Summing on report from separate queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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?
 
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.
 
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
 
Back
Top