I admit - I'm a simple user but looking to improve skills.
Instructions aren't helping and have searched this group but am getting
bogged down by some of the programming-speak.
I have a query called PAL_PA Summary and in that query I calculate
several fields, all %s: Fed, ITS, SALT which are 3 of the 6 columns for
example. Basically its a query by person that shows the % of their time
spent in these diff fields (they add up to 100%).
I want to set up a field that counts for each person the # of fields
where the resulting % is equal or greater to 15%. So if person A spent
85% in Fed and 7% in ITS and 8% in SALT, their count would be 1. If
person B spent 85% in Fed and 15% in ITS and 0% in SALT, their count
would be 2.
I already admitted I'm a novice right? I've been trying to do this
from the design view and building an expression but am not sure I'm
understanding "expr" vs "domain" concepts and have seen quotation marks
in some of the google dialogue on other topics and so don't know if I'm
somehow supposed to include those in my expression - I apologize in
advance for this request for hand holding... hopefully someone will
take pity :)