Counting Field Results in a query

Gringarlow

New member
Local time
Today, 07:17
Joined
Mar 12, 2013
Messages
8
I am trying to build a calculated field that counts the number of times the letter E appears in 8 fields. the query currently looks like the attachment.
I need to have one more field , lets call it NetFlags, that is the number of times the Letter E is in the row for each Technician.
So for Brown, Tom NetFlags = 2, for White, Paul NetFlags = 4 and Wills,Fred = 0
 

Attachments

Have you Normalized your tables?
 

Users who are viewing this thread

Back
Top Bottom