Appending an incremental Long Integer Field



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

Any help will be highly appreciated – Thanking you in advance


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question