Sum in Report

[kbreiss]

The following query I have totals for each facility. At the bottom of the report I would like a grand total of all of the facilities. I tried using the "running sum," but couldn't get it to work. Please help....Not for sure if there's a function I can use in the report, or if I have to do the query differently or do an additional query w/ this.

Thanks in advance,

Kacy

SELECT FACILITY.FAC_NAME, Count(*) AS Totals
FROM Archived INNER JOIN FACILITY ON Archived.FAC_ID = FACILITY.FAC_ID
WHERE (((Archived.APPT_DATE) BETWEEN [Enter Start Date mm-dd-yy] AND [Enter End Date mm-dd-yy]))
GROUP BY FACILITY.FAC_NAME;
________
Nexium injury lawyer

 

[kbreiss]

I got it figured out. I was putting the sum textbox in the page footer and it did not like it. Once I put it in the report footer it was working fine.
________
Bong