Adding some sort of counter?

[Kimberly Anne]

Hi all. This is my first attempt at both Access and SQL in general, so
this may be a dumb question.

I have a table that is created as the result of a maketable between two
other tables. Is there any way I can add an ID number to this new
table in the maketable query? It doesn't matter what the ID is - each
record just needs a unique identifying number. I'm not at all familiar
with VBA so this isn't really an option unless there is no way to do it
within the query.

Thanks, Kim

 

[Jerry Porter]

Hi Kim,

An easy way would be to create the table first, and include a field of
type AutoNumber. Then use an Append query instead of Make Table to add
the records.

Jerry
Kimberly Anne wrote: