Clearing items with different signs (+) and (-)

[The_Qiu]

Hi Access Guru's



I have a table with tbl_desc and tbl_amount columns. In the amount coulmn i have values (+) and (-).

I would like to delete all records that have same tbl_desc and opposite sign from my table.

Would it be possible to get this with querie or macro/SQL is required ?

Thank you in advance for any help with that.

TZ

[June7]

So you want to keep the positive records?

[ranman256]

qsPos query to pull all + items
qsNeg query to pull all - items

in Query3, join the qsPos to qsNet on [Desc] and ABS(Amt) .
and make a delete query on Q3.

Note: delete queries must be done similar to FIND DUPLICATE QUERIES.
use the query wizard to make a Find Duplicate query, look at the design, build the same IN structure for your delete query.