Calculation or summary

[Philip Jenks]

Greetings from a novice.

I have a file called 'Products sold', and every time I sell a product, a record gets added to it. So if I do a Find on records created in the last week it might show:

1 x product X

3 x product B

2 x product Z

1 x product Y

1 x product X

1 x product Y

1 x product B

1 x product Z

and so on.

What I want to be able to do is:

1. Choose a date range for records added to this file

2. Add up the total number of sales for each of the products in that period (above it would show 3 of X, 2 of Y, 3 of Z, 4 of Basically, just see how many of each product I have sold.

A Summary field of products sold doesn't do it, because it just adds ALL the numbers. Is there a way of getting FPro to do additions on a per-product basis?

Thanks

[comment]

Is there a way of getting FPro to do additions on a per-product basis?

Yes - add a sub-summary part by product to your layout, and place the summary field in that part. Records must be sorted by product.

[Philip Jenks]

Thanks.