When you say you want one row you mean one row per peron at each division with a sum, correct?
If so son't bother with a SQL statement.
Add your table.
Group on Division. Right click on the division group field and select Format field. Select Common tab and check the "suppress" box.
Add in group 2 as person. slide it to the right on the header field.
Add the division field (not the group but just the field) on group header 2 just to the left of your person group name.
Click on INsert Summary function (sigma sign).
Field to summarize is your "int" field.
Calculate as SUM
Summary Location is group level 2 (person level).
it will default to the group2 footer. Grab it and move it to group header2 just to the right of your person name.
Go into the secion expert.
Click on Report header 1 and select SUppress Blank section.
click on details, group footer 1 and 2 and do the same thing.
Preview your report.
See if this is what you wanted.
If not, let me know what is not showing correctly.
IP Logged
