P
Palto Fondberg
Hi
I have a table of 5 columns whereby field values are either positive,
negative or level. I've constructed a query whereby the results are then
converted to either "P" for positive, "N" for negative or "L" for level.
What I want to be able to do is count all of the "P"'s in say column one and
then divide this result by the total for that column ie: P+N+L. I want to do
this for all five columns. Will I need to use an SQL approach?
thanks
I have a table of 5 columns whereby field values are either positive,
negative or level. I've constructed a query whereby the results are then
converted to either "P" for positive, "N" for negative or "L" for level.
What I want to be able to do is count all of the "P"'s in say column one and
then divide this result by the total for that column ie: P+N+L. I want to do
this for all five columns. Will I need to use an SQL approach?
thanks