Unanswered: Getting a Total of all Values (Not Just Top 25)
I've set up a report that pulls the top 25 values of a field([ Total]) from a query ([Supplier]). It's easy enough to get the sum of the 25 values. Is there a way to put the sum of all the values(not just the top 25) on the same report?
If the query is based on a more complex query, you could use a subreport and place the "select sum()" statement there. Alternately, you could use a subquery, and attach the number to each record, that method is a little bit of a memory hog, but it will work just dandy if you aren't too concerned with optimal performance. That might look like this:
SELECT TOP 25 yourField, yourOtherField, (SELECT Sum(YourField) FROM yourTable WHERE somestuff) AS yourTotal
WHERE some stuff