N
newsnet customer
Hi
How do I remove redundant rows in a table?
Consider the following table:
tblMyTable
ID1 ID2
01 02
01 02
03 04
04 05
06 07
want
ID1 ID2
01 02
03 04
04 05
06 07
what I have tried:
1. manually removing redundant rows but got cramps cos i have a very large table (~10,000 rows).
2. set ID1 as unique but Access complained that there were duplicates so would not let me. is there a way to force access to do this and therefore automatically remove the redunt rows for me... that would be the easiest way i think.
Help would be much appreciated.
Cheers,
ST
How do I remove redundant rows in a table?
Consider the following table:
tblMyTable
ID1 ID2
01 02
01 02
03 04
04 05
06 07
want
ID1 ID2
01 02
03 04
04 05
06 07
what I have tried:
1. manually removing redundant rows but got cramps cos i have a very large table (~10,000 rows).
2. set ID1 as unique but Access complained that there were duplicates so would not let me. is there a way to force access to do this and therefore automatically remove the redunt rows for me... that would be the easiest way i think.
Help would be much appreciated.
Cheers,
ST