Deleting orphaned data

[Wowbagger]

Using Access 2000, I have a table which includes some "orphaned" data that I
would like to eliminate.

Each record has an X and a Y coordinate used to identify the source of the
values. Some of these are wrong, and are easily identified by an X,Y pair
that includes one and only one point. Is there an easy way to search for
all X,Y pairs that have one and only one point and delete that record?

For example

A1 has one value
A2 has six
A3 has one
B5 has nine
C8 has four

I want to eliminate the records (deleted from the table) that provide data
for A1 and A3 and leave everything else alone so my final query will show
only
A2 six
B5 nine
C8 four

Thank you

 

[Alick [MSFT]]

Hi,

I think one method is that you can try ADO, loop though the table and check
each record/row, once it meets the deleting condition, delete it.



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.


--------------------
| From: "Wowbagger" <none>
| Using Access 2000, I have a table which includes some "orphaned" data
that I
| would like to eliminate.
|
| Each record has an X and a Y coordinate used to identify the source of the
| values. Some of these are wrong, and are easily identified by an X,Y pair
| that includes one and only one point. Is there an easy way to search for
| all X,Y pairs that have one and only one point and delete that record?
|
| For example
|
| A1 has one value
| A2 has six
| A3 has one
| B5 has nine
| C8 has four
|
| I want to eliminate the records (deleted from the table) that provide data
| for A1 and A3 and leave everything else alone so my final query will show
| only
| A2 six
| B5 nine
| C8 four
|
| Thank you
|
|
|