append query results in footer

[JP]

I have a standard Access report with totals in the footer.

I need to append two additional results of a query below the footer and sum
those up.

query1 returns the count of an item meeting a criteria for example 50
query2 returns the count of an item meeting a criteria for example 75


I need my report to look like the following

Name Total

abc 25
def 30
------------
sum 55

append this:
query 1: 50
query2: 75

 

[Duane Hookom]

I would union query1 and query2 and use this as the record source of a
subreport.