Report totals Query Total Vs Table Total

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 Noblet wrote:

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")

--
Marsh
MVP [MS Access]