Report totals Query Total Vs Table Total

  • Thread starter Thread starter Michael Noblet
  • Start date Start date
M

Michael Noblet

I am writting a report that I need to have filtered so I
wrote a select querry that limits the records for the
report. The filed of intrest is the number of XRay
films. For comparison in the report footer I need the sum
of Xray films from the table and not the query.

I tried using the expression builder with the table name
and filed for the total function, but I get the filtered
total rather than the table total

Any Ideas
 
Michael said:
I am writting a report that I need to have filtered so I
wrote a select querry that limits the records for the
report. The filed of intrest is the number of XRay
films. For comparison in the report footer I need the sum
of Xray films from the table and not the query.

I tried using the expression builder with the table name
and filed for the total function, but I get the filtered
total rather than the table total
Click to expand...

Try using the DSum function to total the field in the table:

=DSum("XRay", "table")
 
Back
Top