Running sum ? --diff than bobby's (1 Viewer)

RpbertS

Registered User.
Local time
Today, 11:01
Joined
Feb 14, 2000
Messages
93
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
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:01
Joined
Feb 19, 2002
Messages
42,970
Eliminate the records you don't want to print in the query.
 

RpbertS

Registered User.
Local time
Today, 11:01
Joined
Feb 14, 2000
Messages
93
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
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:01
Joined
Feb 19, 2002
Messages
42,970
Use a query rather than the table as the recordsource for the report. That way you can select only the rows you need.
 

Users who are viewing this thread

Top Bottom