Need help..
I have a table which has several fields like:
Art_Discipline_1 (which contains numeric value from 1 to 24)
Art_Discipline_2 (which contains numeric value from 1 to 24)
Art_Discipline_3 (which contains numeric value from 1 to 24)
There is one number per field that can be entered.
I want to be able to make a query based on a specific value that will search for that value in Art_Discipline_1 OR Art_Discipline_2 OR Art_Discipline_3
Let's say I want to search the value 13 in Art_Discipline_1 OR Art_Discipline_2 OR Art_Discipline_3....what should I type to get those results...
I will enter the value in a list box and after pushing a button, it will execute the query based on that entered value.
Thanks
Pjay