Delete record with 6 equal field

D

Dante

Hi from Italy,

i have a table with several hundred of record like this :


1 2 3 4 5 6 7 8

1 2 3 4 5 6 8 9

1 2 3 4 5 6 9 10



i want to delete all record that have 6 number equal, so in the example
above

will be remain only one record (not importance who remain)



I have tried with a query, but i think that vba is the solution (i don't
manage it).



Can you help me ??



Many thanks in advance !!
 
J

John Vinson

Hi from Italy,

i have a table with several hundred of record like this :


1 2 3 4 5 6 7 8

1 2 3 4 5 6 8 9

1 2 3 4 5 6 9 10



i want to delete all record that have 6 number equal, so in the example
above

will be remain only one record (not importance who remain)
Click to expand...

This will be rather difficult with a Query, if I understand aright. I
presume if there is a record with

8 11 3 1 2 5 4 6

that it should be deleted too, since it contains fields with values 1
2 3 4 5 6? Or are you talking about matching first field to first
field, second to second and so on? Even THAT will be a messy query
since there are 56 possible matchings of six fields out of eight; the
brute force approach would involve 56 Delete queries, each with a
subquery, or a (impractical, because of query size) query with 56
subqueries.

Hmmm... a real challenge!

What is the background? What is the source of this data?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
D

Dante

This will be rather difficult with a Query, if I understand aright. I
presume if there is a record with

8 11 3 1 2 5 4 6
No.

that it should be deleted too, since it contains fields with values 1
2 3 4 5 6?
No.

Or are you talking about matching first field to first
field, second to second and so on? Even THAT will be a messy query
since there are 56 possible matchings of six fields out of eight; the
brute force approach would involve 56 Delete queries, each with a
subquery, or a (impractical, because of query size) query with 56
subqueries.
Hmmm... a real challenge!
What is the background? What is the source of this data?
Click to expand...

I hope to be clear :
***This is for a play similar your Lotto or Bingo, where for win you have to
forecast 8 number on 32 *** First number is 1 Last is 32 .
I have a table "Pronostico" with only field "NR" where I put some MY numer
from 1 to 32
(sometimes i put in 20 number, sometimes i pun in 15 number ecc ecc
example of number so are :
2
4
5
7
9
10
11
13
ecc.

After I generate all possible combination for all number i put in
table "Pronostico" TAKES FOR CLASSES 8
so for the number above some, combination generate will be :

2 4 5 7 9 10 11 13
2 4 5 7 9 10 11 14
2 4 5 7 9 10 11 15
2 4 5 7 9 10 11 18
ecc ecc

Now I Want delete from this record all record that have 6 number equal !
But i don't know how to this !

thanks for help !
 
Top