Calculations for Insert Report

[shorty]

I have a database that has fields:

Full Zone, National Zone, Date, Day, Advertiser, Pgs, Type, Col, Inch, Total Inches, % of insertions, Sales #, # of Copies, Inch Charges, Total Charges. These are on a data entry form.

I have an Insert Report Layout that prints everything listed and a trailing grand summary that summarizes pgs, total inches, # of copies, inch charges, total charges.

Now I need on that same layout subtotals of the amount that is full zone, National zone, without separating them on the report like a sub sorting.

Any help on this situation would be helpful.

Thank you

[danjacoby]

How bout a calc field using the "sum" function?

Not sure exactly what you want, but this might be the answer.

[shorty]

When I use the calc Sum field it only brings me back to the last record. So if the last record says 8457 then my sum calc will show 8457. I was wandering if there was a way to use the If calculation.

So IF Zone Type= "F", then the Sum(# of Copies),0); This would give me just the total of the F(Full Zone) copies. But I can't get this to work either.

This problem is beginning to drive me to doing it by hand.

HELP!

shorty

[LiveOak]

To summarize parts of the records in your file without using subsummary parts in a report you must indeed use the Sum() function, BUT in concert with relationships that isolate the subset of records you wish to summarize.

Sum(relationship::field) will add up a field for those records which meet the criteria of the relationship. If the relationship relates the Zone field to the Zone field, it will add up all records which match the Zone of the record you are currently on. If you don't want it to be dependent upon which record you are currently on, the relationship could be based upon (left side of the relationship) a global field set to the zone value you desire.

-bd

[shorty]

Is there an example that you could post. I am a little confused. I now have fields named Global Full Run and Global National. I need it to summarize the Full Run # of Copies.

TIA

shorty