Grouping and Reports

L

Lost

OK...let me start this one off by saying once again...I'm not an access
person but been charged with figuring stuff out...

I am creating a report..in that report I have a field that has lengths in it
and a field that has a permission type in it. We have been using this report
for the entire list, but now they are wanting to add a total length, but for
just one permission type.
I have a query built to just give me the permission type I am looking for,
but I cannot get it to sum it all up and add that to the bottom of the report.
 
W

Wayne-I-M

In the footer or header of the report create an unbound text box and use this
is the source


=Sum(IIf([permission type]="ABC???",Nz([lengths],0)))


Change
[permission type] to the name of the control (not the field name) that
contains the permission type you want to sum

ABC??? to the permission type you want it to be (you didn't say)

The Nz([lengths],0) is just in case (always a good idea to have a "just in
case") the permission type you want to sum have a record with no length


Good luck
 
Top