A
ab
I have five fields (a registration table) into which registrants place
their top five topics - one in each field. However, since the applicants
can choose from ten choices, some folks have choice "A" in the first
field, others have it in the second field with choice "B" in first
field, etc. I need to end up with all registrants for choice A in one
query or report--regardless of whether choice A is their first or fifth
choice. Can I do this? I can get a query to use "or" for the first 3
columns but it won't continue to pull from columns 4 and 5. PLease help.
their top five topics - one in each field. However, since the applicants
can choose from ten choices, some folks have choice "A" in the first
field, others have it in the second field with choice "B" in first
field, etc. I need to end up with all registrants for choice A in one
query or report--regardless of whether choice A is their first or fifth
choice. Can I do this? I can get a query to use "or" for the first 3
columns but it won't continue to pull from columns 4 and 5. PLease help.