Can a query create an autoincrement field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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>
 
Back
Top