Okay I have a running sum on a report that gives me totals on the bottom, also when certain conditions are met some records are not shown/printed but the problem is when this happens the running sum totals are still adding up the records that are not shown..is there a way to skip the certain records that meet the conditions? or am I stuck making another report?

thanks,
Rpb

Eliminate the records you don't want to print in the query.

thanks Pat I tried to find out a way of eliminating the records from the reports without actually deleting the records from the table but I havent yet could you or anyone else point me in the right direction?

thanks,
Rpb

Use a query rather than the table as the recordsource for the report. That way you can select only the rows you need.