Need help with vba for if else statement for three values: Completed, in progress & not started

[ATTHECROSS]

Hello All -



I need a VBA code where Column "A" has three variables: Completed, In Progress & Not Started. Based upon the variable I need Column "B" to show a "3" for "Completed", a "2" for "In Progress" and a "1" for "Not Started." I am new to VBA and very new to If Else statements so I appreciate everyones help. I would like to run this in Access as part of a report output, but is that even possible or do I just need to run the VBA in excel once I have queried the data in Access and dumped it into excel?

Thanks in advance for the help!

[John_G]

You can use the MS Access switch function:

Column_B = switch([Column_A] = "Completed",3, [Column_A] = "In Progress", 2, [column_A] = "Not Started", 1)

The function returns a Null if [Column_A] is not one of those three values.

[ATTHECROSS]

John_G

Thank you for your time! That worked perfectly! Happy New Year