sub summaries?

[davepain]

any one help??

as an example i have 20 records, within this 2 different products (10 of each) defined by a field (product code)

there is 2 other fields cost per unit and sales value per unit.

I want to have two summaries of the total or avarage of these two fields for each independent product.

Thanks.

[Peter Fenner]

What do you mean by: "Sales Value per unit"? Do you mean quantity sold of that product?

Pete

[davepain]

sales value as in sell price,

Dave.

[Peter Fenner]

If these summaries are for a report then you will simply create summary fields. When creating these summary fields the dialogue box is self-explanatory (ie: Total of...your selected field in dialogue box)

On your layout create a new "part". This part will be a sub-summary sorted by product. Place the summary field on this part of the layout.

You can also create a trailing (or leading) grand summary layout part. Place the summary field here as well, and you will get the result for all found records, not just product-by-product.

You will need to sort your records by product and swop from browse to preview mode to see your end result.

If you need to access this result in browse mode, then create a calculation field as follows:

GetSummary (summary

[toadspittle]

I have a similar issue:

Small company (2 - 4 workers, depending on project). I'm already using a time billing db to track hours, total hours billed, etc. But I'm creating a project database to track the info. for each project (namely, how long we estimated it would take, how long it did take, what we charged, if it's been paid, etc.).

Here's what I need to do:

Summarize (from the time billing db) the records for each work entry (i.e., how many hours that employee spent that day on that project), but separated by project and worker. That way we'll know how long each person spent on each project, and what their time cost the client.

> GetSummary (summary

[Peter Fenner]

I am not sure, but possibly by creating a calculation field that "joins" project and employee id into one field. This then becomes the breakfield. Logically, it should work - but I have very little experience with GetSummary (none in fact). Give it a try though.

Pete

[toadspittle]

Thanks. I'll give it a whirl.