Complicated (?) IIF in query 1

[cuok]

Hi all!

i would appricate for any help!

I have 4 fields in table:

F1, F2 F3 and TotalF

each of them can valued by: "S" or "T"
if 2 or 3 of them got "S" then TotalF=2 otherwise TotalF=1.
how can i do it?

thanks in advance
CUOK

 

[dhookom]

Are you attempting to store a value that can be calculated? If so, do you have a good reason for this?
I suppose you could create an update query that
SET TotalF = IIf(Abs((F1="S"+F2="S"+F3="S&quot)>2,2,1)

Duane
MS Access MVP

 

[cuok]

Many thanks dhookom for your help,
i used it as a basis and it works fine.
have a star my dear!
CUOK