Hi All,
Ok. Here's what my table looks like:
Field1 Field2 Field3 Field4...
Record1 1 3 2 9
Record2 9 1 9 4
Record3 1 3 1 2 etc, etc.
What I want to do is for each record, count the number of values across the
fields. Specifically, I want to count the number of 9's in each record, so
in the above example, Record1 would have 1, Record2 would have 2 and Record3
would have 0.
I know how to count values in a particular field across records, but I can't
figure out how to do it across fields for each record. I've searched all
over the web and not found an answer. Has anybody here done it? If so,
how?
My SQL and VBA knowledge is limited, but I'm always up for learning new
things.
Thanks,
Zb
zbornema@ pitt.edu
(remove space from email address)