How to have a report give me a TOTAL from a query

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

My query is:
SELECT Count(Customer.Suffix) AS CountOfSuffix,
Customer.Register, Customer.IDProfession
FROM Customer
GROUP BY Customer.Register, Customer.IDProfession
HAVING (((Customer.Register)=-1));

I am attempting to get a grand total of the count, I have
tried =Count(*), =Sum(CountOfSuffix), =Sum(Suffix)....
Any help would be appreciated. TKS in advance.
 
The following should work.
=Sum(CountOfSuffix)
Did you place this in a REPORT FOOTER section? You are suggesting that these
didn't work but you don't tell us what the symptoms might be.
 
I am putting a unbound text box in the footer and in the
control source I am entering: =Sum(CountOfSuffix)and
when I preview the report it shows #Error in the footer.
Thanks for the help
 
Rose,
Which footer? Since my previous reply made it fairly clear that your text
box should be in the REPORT FOOTER and I asked you this, wouldn't you want
to provide this information?
 
I was not specific, sorry. I also just realized I was
putting it in the PAGE footer instead of the REPORT
footer it is working!!!! Now I have to get working on my
next project, thanks for your help. !!!!
 
Back
Top