Determining whether the same recordsets are being compared

[JulieS]

Hello,

I am assigning IDs by first going through the records and determining which records are duplicates (from there I flag the duplicate with a -1 in the ID field, then delete all the -1s before I assign the ID). Just for some background info.

I have a Current and Next pointer looping through the records (each next recordset is compared with the current, and then incremented). The problem is when I am on the same recordset - is there a way of determing whether the Current and Next pointers are on the SAME recordset, rather than the Next being just a duplicate?

(I can't set any properties to allow no duplicates, because I am importing the data, and this is to remove any data that has been imported more than once).

I've been working on this forever, and am getting nowhere, so any help would be greatly appreciated.

Thanks so much,
Julie

 

[mymou]

JulieS


Have you checked 'Automatically delete duplicate records from a table' in help.

Might be what you need.


Stew

 

[JulieS]

Hi Stew,

I had looked at that, but my problem is that I don't have anything for a primary key value yet (as i don't want to assign that until I'm clear of duplicates).

I tried the automatically delete duplicates, but due to not having a PK, it just appends all the records to the tabls.

hrmp.

Thanks anyway,

Julie

 

[mymou]

Hi JulieS

If this is just a one off import of data - can't you just create of numbered column (import into a table with a autonumber as a PK) and this will then allow you to delete the duplicates (or flag non-duplicates). Then delete the PK column.

I would suggest you stick to SQL for this issue - as I've seen lots of people here tie themselves in knots doing just this.

Stew

 

[MichaelRed]

Ugh.

See response to your other post.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over