I have an existing Access report whose record source is a union query.
The primary key of each of the tables is a compound key if I'm using the correct terminology (the primary key of each table is made up of 4 separate fields)
I need to display the total record count of the records on my report. Let's say my report displays 100 line items (ie records). I need to also display something like "Total Records: 100" or whatever. How do I do it?