Summary data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to avoid having SumOfSumSumOf.... . I have developed several
reports using queries that summarize data from other queries Most of the
data has 3 or 4 grouping levels. I guess I am asking is there a better way to
use aggregate functions other than just summarizing data from other queries,
and not have to build so many queries.
 
In design view create an alias like --
Total for XXX: YourFieldName

In SQL add --
AS [Total for XXX]
instead of your SumOfSumSumOf....
 
I can't tell if you object to the queries or object to the "title".

You can "alias" a field in a query to have whatever title you wish.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I should have mentioned that I don't mind having to use an alias. My question
really is regarding the need for having to create so many queries to get a
sum and keep the grouping levels I need.
 
Without a bit more description of your data and how you are querying it, it
will be tough to offer suggestions about how to simplify the process.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top