Report totals Query Total Vs Table Total

[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

 

[Marshall Barton]

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

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

=DSum("XRay", "table")