Access Report on Parameter Query

[BFRChief]

I have a report established identifying data based on a query for a single
report month. Amounts are identifed by program and totaled. One of the
categories are then segregated and the balance totaled. The report is built
on the query but the formula used to segregate that category pulls from the
table as follows:

=DLookup(“[SAL & BEN]â€,â€CLIENT SUPPORTSâ€,â€[MONTH REPORT]=#â€&[MONTHREPORT]
&â€# AND [ADMIN]=’PA’ “)

I need to segregate the same category for the parameter query which pulls
multiple report months but have been unsuccessful thus far. Suggestions?

 

[Duane Hookom]

If you want to total a subset of the records in a report's resultset, you can
try:
=Sum([SAL & BEN] * Abs([ADMIN]="PA"))
If that's not what you want, please reply back with more information about
your report and calculation.

 

[BFRChief]

I'll try that and will let you know. Thanks!

 

[BFRChief]

Thanks - that works! I had to change the one field name to [SumOfSAL & BEN]
since the report already summed the totals by program. Great - I LOVE it when
a plan comes together!

If you want to total a subset of the records in a report's resultset, you can
try:
=Sum([SAL & BEN] * Abs([ADMIN]="PA"))
If that's not what you want, please reply back with more information about
your report and calculation.

--
Duane Hookom
Microsoft Access MVP

I have a report established identifying data based on a query for a single
report month. Amounts are identifed by program and totaled. One of the
categories are then segregated and the balance totaled. The report is built
on the query but the formula used to segregate that category pulls from the
table as follows:

=DLookup(“[SAL & BEN]â€,â€CLIENT SUPPORTSâ€,â€[MONTH REPORT]=#â€&[MONTHREPORT]
&â€# AND [ADMIN]=’PA’ “)

I need to segregate the same category for the parameter query which pulls
multiple report months but have been unsuccessful thus far. Suggestions?