Till equivalent

[rservis]

Hi,

I am trying to emulate a till and be able to produce a report that shows the complete breakdown for a days activity.

Any time something gets purchased or a service gets done an entry gets put in the line items table and the type field gets updated with either Product or service.

I want to show how many products and services we sold and what was the price for each.

I have created a how many products calc field with a case function "Case ( Product Type = "Product";1 )" and then have a summary show the total, which works. The next step is to show how much was taken for products. Can anybody help.

Thanking you all in advance,

Best

Roy