MS Access 97 query - Checkboxes to new field
Posted on 2009-05-15
We have an Access Database which we are trying to port over to an Act Database. Within the Access database are a number of checkboxes for example Type of Customer. What I would like to do is have a new field called CustomerType which has the name of the Customer Type if it has a checkbox.
To illustrate - let's say you have Tinker, Tailor, Soldier, Spy and one of those is ticked. If Tinker is selected then update that record with the new field ID and have that say Tinker.
I guess it can be done with a case statement but I am not sure the syntax
In Psudocode something like
if Tinker = Yes then CustomerType=Tinker
If Tailor = Yes then CustomerType=Tailor
Else if Blank then CustomerType = Blank
Thanks in advance for any help / tips /websites to check out