General SQL Query

Hi,
I have a small problem you may be able to help me with. Basically, I have a small database with 1 table. There are 7 fields in the table - date, one, two, three, four, five, six. With the exception of the date field, the other fields hold integers.

What I am trying to do, is create a query that will allow me to select data from the table based on user input - for example, each field holds one number, between 1 and 10 and each row holds 6 numbers and a date, I want the user to be able to input 5 numbers individually into the query and if those 5 numbers appear anywhere in any of the rows, the data is returned.

So if the user inputs, 2, 10, 9, 8, 5 and there is a row in the table with --->

Date One Two Three Four Five Six

12 Nov 6 9 8 5 10 2

Then that row will be returned. This is 'hopefully' probably simple, but I have tried everything I can think of including subqueries, seperating the fields into different tables and using joins - but no joy. I would appreciate any help at all. I'm using MSAccess XP

Thanks..........Enda

I think your table structure needs to be revised. It will be very difficult to do that with that table structure. The numbers should be broken out into a seperate table.

Having said that, this might work: Assuming numbers selected were 1,2,3,4,5