5 fields of topics/record...find recs with any = parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My record has topic1, topic2, ...topic5. I need to retrieve any records
where any of the five = my input parameter. How can I best go about this?
 
Dear taash_fwtx:

By normalizing your database, you would then have a table with only
one column for topic. It may require another table to accomplish
this. You can then use the tools provided in queries to accomplish
the things you need by using them in the manner they are intended to
work.

For details on how to accomplish this, please provide much more detail
of your situation.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
IF you are stuck with the structue try reversing the comparison.

WHERE [Input Parameter] in (Field1, Field2, Field3, Field4, Field5)

Usually when you need to do something like this it indicates that there is a
design problem in your table structure, but sometimes you can't correct the
table structure because you don't own the structure.
 
Back
Top