Sorting & Group totals

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I have a table with among other things has first-name,
last-name, and orgainzation. Some records only data in
the orgainzation field, some only have data in the last-
name field, some only have data in the first-name field,
and some have a combination of the three.

I want a sorted report where the records with only data in
the orgainzation field would come first and then
everything else sorted on last-name/first-name. I also
need footers for each group of data, so I can have totals.

Any Help?

Thanks,
Phil
 
Hi Phil.
With the report in design view, open the View +
Sorting/Grouping window. In the 1st Field/Expression
field enter:
=IIf([Organization] Is Not Null,1,IIF([Last-Name] is not
null,2,3))
Set the group header and footer as desired, this will
create three footers providing there is some data for each
group.
Hope this helps.
Fons
 
Back
Top