increment fld in table

[jedder18]

Have a current table with an autonumber field already included.
I need to create a field in same table to increment numbers by 1 since we can't have 2 autonumber flds in a table.
How do I make this happen in a table?
I know how to make it on a form in a control but not as a table field.

My brain is foggy today,..stayed up to watch the CAVS beat the Warriors in game 6 of Finals....

 

[Ranman256]

set the field to number: long integer.
then you can increment it from a form or query.

 

[jedder18]

way too simple....

The fog has not lifted....