G
Guest
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
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