How To Display Summary Values in Access Using a UNION Query

A good article from Susan Sales Harkins of TechRepublic.com on a fast no-frills way of returning a row of summary values using UNION. Normally, you use SQL’s UNION operator to combine data from two or more tables or queries, but you can also use it to display detail records and summaryvalues.