If Function for Queries

[beginner_access]

I would like queries to do some calculations for me based on a field. The field in the form is a combo field and the user can choose either 1, 2 or 3. Based on the selection, I would like queries to generate some numbers for me.

This is what I have in mind but its not working. Please help

TEST RESULT: If([tlkpTEST].[RESULTID])=1, ([tlkpTEST].[RESULTID])*2, 100)

 

[BlueIshDan]

IIF instead of IF and you're done lol.

 

[beginner_access]

IIF instead of IF and you're done lol.

hahah that was easy. I feel silly. LOL Thank you!!