Doug

If someone asked me (or just about any kid) how to "break" your system, the
simplest approach is to use "Johnny's" number instead of my own. I do hope
you have a way to confirm who you're dealing with...

Since you're looking to automate this, why limit yourself to a sequential ID
#? You could just as easily list the campers by name, and select the
camper's name (along with other 'identifying features').

You've asked a "how do I" question (how do I come up with a re-setting
incrementing ID numbers). But you've also provided a decent description of
the business need (uniquely identify each camper during each camp session).
You might just find some folks here offering alternate approaches to solving
that business need!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Doug" wrote in message
...
I hope the subject didn't throw anybody off...

I'm working on a database which is used for a local summer camp. The camp
has a little snack bar which is run completely manual. Each camper is
assigned a unique number (for that week's camp) which the snack bar
operator
can then use to access the camper's account (all done on paper).

The database is used to register campers, track finance and assign camp
cabins. We'd like to also assign the snack bar number automatically...
but
we want the number to reset for each camp (ie - for each camp keep a
running
number). The reason we don't want it to continue to run is so the kids
can
more easily remember a low number (150 max). To make things more
confusing -
we are using the database to register kids to multiple camps at a time.
Is
there a way to do this - or do we need to continue manually assigning the
numbers?