January 23, 200818 yr 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
Create an account or sign in to comment