Can a query create an autoincrement field?

[Guest]

An application I need to export to requires that each record in the query I
run have a unique ID field. This would be accomplished in a table via use of
the autoincrement field type, but I'm not sure how to create a new field of
in my query to provide the same function.

Any suggestions?

Thanks!

-Michael

 

[Jeff Boyce]

Michael

If you are using a query to collect (and export) data, could you include a
field in your query which is the autonumber field from the underlying table?
Would that satisfy the application to which you are exporting?

If not, another approach might be to use a query to append records to a
table used only to export. Define the table with an Autonumber ID field.
Then create an export query that reads from that table, including the ID.

Good luck

Jeff Boyce
<Access MVP>

 

[Van T. Dinh]

If you don't have a AutoNumber Field in the Source Tables that you can use,
try Stephen Lebans' "RowNumber"

http://www.lebans.com/rownumber.htm