Multiple summaries

[UFOGoldorak]

Hello —

I have 2 tables. On the main I have a portal for items (description, qty, price etc..) Some of these items will be marked with a checkbox to say that this item is a stock (ie paper, boxes, shrink wrap etc..) and not actual product.

Items table and main table are related through a Jobnumber..

Right now on the items table I have a sum field for a total. This gets me a total for all the items in that job. I need to be able to get a total of my products and a separate total for my stock. Is that possible in one table?

Thanks,

Paul

[Fitch]

I assume you want a price total, rather than a count?

You could make a calc field for each item:

Case( checkbox; price ) // stock

Case( not checkbox; price ) // actual product

And then in main use Sum on these fields.

[UFOGoldorak]

Pure genius.. Much appreciated!