Is there an Internal Record Row Id in Access tables? 1

[saraUSIT]

I'm trying to run a query thru a module on a table that gets created in middle of the module, and there is no primary key or unique fields. I need to find the duplicate records, but since there is no unique identifier it makes it complicated - is there a way to query on an internal record row id - then I would select the min row id for all duplicate records? If not, how would I add an autonumber field to this table in the module that I can then use to do the min select?

Thanks for your help.

 

[PHV]

how would I add an autonumber field to this table in the module
DoCmd.RunSQL "ALTER TABLE yourTable ADD myRowID COUNTER(1,1)"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886