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.