Unanswered: auto numbering but not for every record
i have a table with persons in it. Some of them are members, others are not, unfortunately they are in the same table
So some of them have membership numbers, and others don't.
When I enter a new record in a form, is it possible to have the form automatically create the new membership number if I indicate that the new person is a member? The new membership number should just follow up the last...
Ahhhh, well one could manually make entries into this table I suppose. Of course that brings us back to the original suggestion.
If you want extra credit, I would go with a nonsyncronous semi-analogous variable array approach. Granted it's a little advanced, but it scored me big bonus points with my instructor! A lot of people don't think to incorporate the nonsynchronous aspect of randomization, but I've found it greatly improves overall quantum performance...
Try something like this:
Select Max(yourField) + (Int((.6 * Rnd) + 1.4) * (3.14 ^ 0)) As YourNextKey
WHERE Max(yourField) <> -3.14
That looks a very intersting way of generating the next memebrship number. I'm particularly impressed with the stochastic use of the rnd function, I would never of thought of that, but then pros like you must know these things of Pat(P)