Access Report on Parameter Query

  • Thread starter Thread starter BFRChief
  • Start date Start date
B

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?
 
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.
 
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!

Duane Hookom said:
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


BFRChief said:
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?
Click to expand...
Click to expand...
 
Back
Top