Unique field in Query? 1

[foundryqa]

I have a query drawing from a table that has no unique ID for each record. I cannot change the table to add an autonumber field or someother unique identifier. Is there some way to add a unique ID to each of the records in the query? Thanks in advance.

 

[tlbroadbent]

Sounds like you want a row number on the result set. Check the following links.

faq701-1155 thread181-142288 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[foundryqa]

Thank you Terry. That was exactly what I needed.

Fred