append query results in footer

  • Thread starter Thread starter JP
  • Start date Start date
J

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
 
I would union query1 and query2 and use this as the record source of a
subreport.
 
Back
Top