Appending an incremental Long Integer Field

[George]

Dear friends,

I have a table tbl_Members and every year I will sent subscription invoices
to those members, once a year. I need to run (I don’t know – perhaps a
query) in order to append into the table tbl_MembersSubscriptions for each
member one record. I need to record in that table the invoice number and as
you realise I have to set this to a Long Integer and not an Autonumber. How
can I do that in order to append those members subscriptions invoice Numbers,
each one to be incremented by one without having dups and also not to have
gaps.

Any help will be highly appreciated – Thanking you in advance

George

 

[S.Clark]

An append query will append a long integer value into an AutoNumber field.

Your best bet may be to make a dedicated primary key field as a AutoNumber,
and your invoice field a Number of Long Integer.


--
Steve Clark, Former Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html