Recent content by rjordan

It was my error I had the wrong view set. Thanks Randy

I wonder if it is because I am using access 2007 Randy

Thanks for the reply and the sample. I am curious if the sample you sent was supposed to have the queries you mentioned, I don't see them I only see the tables. Thanks Randy

That is axactley right.... can it be done Thanks Randy

The numbers are stored in #1 through #5 Each record is a draw of 5 numbers between 1 and 39 Ican post a smaller version of the database if needed say maybe just 5 records Thanks Randy

I have a database with around 5083 records and I am trying to find the three most common numbers called in any one record such as 5 22 and 39 has been called together 50 times Here is the structure # 1 through 5 is a number between 1 and 39 but never duplicated in same record Record 1...