Basic google searches provide impressive results.
https://www.google.com/search?q=ms+a...tals+on+groups
What I want is to grab the number directly from the totals row in the query. I googled it but I am thinking it isn't possible. Is it only in the query datasheet view only and you cannot tell the report to grab it from there?
Have you tried creating a text box and using the Sum() function as the Control Source
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick