Thread: What is best way to re-use an account number? in microsoft.public.access.formscoding

  Access Vandal, We are not reusing the "account number". Each member is assign a account number that NEVER changes. And I should have been more clear. We do not "delete" a member. We flag the the member as "deleted". The number we are re-using is a "door prize" number. This number is used to reward prizes to members at different fund raising events. They are...

  Dennis - I assume you have a valid reason for re-using the numbers, and cannot just create new ones. Do you need a different set of numbers for each fund? In your Background section, it sounds like one number per person. I am not sure of the 'group' that a member leaves, causing them to be deleted. If you just need one number per person, then this might work for you: Questions 1 and 2: Create a tblFundRaisingNo that has...

  Dennis wrote: > > I will create a table called tblFundNo, which is keyed by the fund > raising number. There will be a special row keyed by the number > zero. The zero row will contain that last used high number. > > The table's structure will be: > > tblFundNo > key : Name = FundNo, Value = A Fund No > fld 1: Name = Available, Value = Y (# is available) or...

  Scenario - Donor 1 is replaced by Donor 2. Since Donor 2 is using Donor1 Account Number, you sum the total donation of Donor 2, you'll get the total sum including Donor 1 contributions. So, how are you going to discern between Donor 1 and Donor 2 contributions? Dennis wrote: >All, > >Thank you for your response. To answer some questions: > >- Do you need a different set of numbers for each...

  Dennis <Dennis@discussions.microsoft.com> wrote: >When a new member joins, they are assigned a "Fund Raising" number. That >number will stay will that member until they leave the group. Once that >member leaves the group, we terminate the member on the system, and their >"Fund Raising" number becomes available to be re-assigned to the next new...