Setting criteria for queries

[red7]

Hey,

I have three fields:

Interests1, Interests2, Interests3.

I need to somehow set up a query whereby I can search if certain criteria is present in ANY of those fields.

I only know how to search if 'football' for example is present in ALL of the fields, or a specific field i.e. 'Interests1.'

Any ideas?

Apologies if I've not explained it very well.

 

[Rich]

You should normalise your db first, then it becomes much easier

 

[red7]

So would creating an 'Interests' table sort it?

Pardon my ignorance

 

[maxmangion]

search this forum for the words normalisation/normalization. You shouldn't have three fields for interests.

 

[red7]

Sorted. Thank you