Calculate % Length of one Criteria against % Length of other 4 Cri

[Mark909]

In a table i want to use two columns to calculate the lengths (m) of
different critera.

A) I want to be able to sum the length of one individial criteria - This is
no problem I simply enter the name of the criteria in the "Type" column and
select Sum in the total column

B) I have 4 other criteria where the total sum of all their lengths need to
be added together. I've tried "Criteria 1" Or "Criteria 2" Or "Criteria 3" Or
"Criteria 4". This gives me the totals of each individual criteria in
seperate rows. I want the totals to eb combined to display the total length
in one row.

C) I then want to work out a Percentage of the Total Length of the criteria
in example A) agains the total summed length of the criteria in example B)

Any ideas? The results will then be displayed in a report.

Thanks for any help.

<M>

 

[Golfinray]

I would think sum([1]+[2]+[3]+[4]) would sum those criteria. Then a simple
division result should give you a percentage. Somthing like ([criteria
sum]/[type sum])

 

[Larry Linson]

Are you talking about Criteria in an Access Query (a very specific thing),
or something else? If you have multiple columns, each with a field that
contains the length of some (other than Access Query) criteria, and none are
null values, you can sum each separately. If, on the other hand, your
columns contain those criteria as strings, then the calculation is a bit
more complicated.

It is generally not a good idea to store in a Table a value that can be
calculated from other values in the table. You should perform such a
calculation in the Query you use for Record Source of the Report, or in the
Report itself.

If you will clarify what data you have, with the actual field names, it is
likely that someone can offer a useful suggestion.

Larry Linson
Microsoft Office Access MVP