Summing different lengths and percentage split --------M---------

[Mark909]

I have a number of different lengths of pipes.

In one column I have the names of the different pipes.

In another column i have the lenght of the pipes in meters.

I want to produce a form that will show me the total length used of one type
of pipe

I then want the total length used of all the other pipes summed together.

After this I want to show the percentage split of the two different summed
values of pipe lengths

 

[Fred]

Your goals all relate to summarizing USAGE of pipes. You need to create or
confirm that you already have a table structure that records usage.

If your current table has a record for each instance of usage, then you have
this.

Assuming this, to avoid repetion n and numerous other issues, you probably
need a table which has a list of pipe types. Then either use it to poplulate
a dropp down list, or link to it.

Once you have the above, make reports from your "instances of use" table,
and put a summing box ( =sum([fieldname]) in either a group footer for
that pipe type or in the report footer.

 

[Golfinray]

You have a number of things you need to do. I would start with a query that
calls your information. From that query, you need to do a totals query (use
the little totals button at the top) taht totals your pipe used. Then another
query that totals all the other pipe summed together. I would then create one
final query that brings in all information and both totals. Run your report