I have a registration form which allows people to tick whether they prefer to be contacted on home, work or mobile phone number and they list the number in a field. Their preference is a tick box.
Fields are: Home Preferred(Yes/No) Home Number(text) Work Preferred(Yes/No) Work Number(text) Mobile Preferred(Yes/No) Mobile Number(text)
I have to generate a labels report from this form to a printer. All is set except I need to ensure the preferred phone number appears on the label. This means I need a formula or a way to ensure if there is a tick box entry for that client next to either Home, Mobile or Work then that phone number is returned to the label.
I suspect a query is in order, or/and an If statement of some sort but can anyone assist.
Fields are: Home Preferred(Yes/No) Home Number(text) Work Preferred(Yes/No) Work Number(text) Mobile Preferred(Yes/No) Mobile Number(text)
I have to generate a labels report from this form to a printer. All is set except I need to ensure the preferred phone number appears on the label. This means I need a formula or a way to ensure if there is a tick box entry for that client next to either Home, Mobile or Work then that phone number is returned to the label.
I suspect a query is in order, or/and an If statement of some sort but can anyone assist.