Adding certain parts of a report

[Guest]

Hi, I have a report that has payroll info in this format

Name Time Taken Amount Paid
John V 40.00
Mary V 8.00
Don S 3.00

The amount paid is in hours and the key for Time taken is V= Vacation,
S=Sick, etc. I need my report to total all of the the one specific time. For
example V = 48.00, S = 3.00. Any help would be appreciated.

Thank You!!

 

[fredg]

Hi, I have a report that has payroll info in this format

Name Time Taken Amount Paid
John V 40.00
Mary V 8.00
Don S 3.00

The amount paid is in hours and the key for Time taken is V= Vacation,
S=Sick, etc. I need my report to total all of the the one specific time. For
example V = 48.00, S = 3.00. Any help would be appreciated.

Thank You!!

Using unbound controls on the report:
=Sum(IIf([TimeTaken] = "V",[AmountPaid],0)
=Sum(IIf([TimeTaken] = "S",[AmountPaid],0)
etc.

 

[Guest]

That worked like a charm!!! Your the best!! Even if that ran through my head
I probably would have over thought it and kept looking for something else.

Thanks Again!!

=)

Hi, I have a report that has payroll info in this format

Name Time Taken Amount Paid
John V 40.00
Mary V 8.00
Don S 3.00

The amount paid is in hours and the key for Time taken is V= Vacation,
S=Sick, etc. I need my report to total all of the the one specific time. For
example V = 48.00, S = 3.00. Any help would be appreciated.

Thank You!!

Using unbound controls on the report:
=Sum(IIf([TimeTaken] = "V",[AmountPaid],0)
=Sum(IIf([TimeTaken] = "S",[AmountPaid],0)
etc.