Elmobram22
Registered User.
- Local time
- Today, 15:04
- Joined
- Jul 12, 2013
- Messages
- 165
Hi,
I am trying to add a value to a column in a query based on the value of another column. I am using an Iif statement for it but can't get it to work. I have a column called [Was Worker Born in UK] which has 3 options of "Yes, "No" and "Unknown". The next column is the [COUNTRYOFBIRTH] column. I basically want [COUNTRYOFBIRTH] to say "866" if [Was Worker Born in UK] is "Yes". Any help would be greatly appreciated.
Cheers,
Elmobram22
I am trying to add a value to a column in a query based on the value of another column. I am using an Iif statement for it but can't get it to work. I have a column called [Was Worker Born in UK] which has 3 options of "Yes, "No" and "Unknown". The next column is the [COUNTRYOFBIRTH] column. I basically want [COUNTRYOFBIRTH] to say "866" if [Was Worker Born in UK] is "Yes". Any help would be greatly appreciated.
Cheers,
Elmobram22