Matt,
Mathematically all you are doing is counting a series that iterates by one
and has a base of 26. Once you generate the next number in the series it's
a simple matter of using the char(ansivalue) function to return the
character for that number. Now, a 15 digit number will give you a maximum
value of 999,999,999,999,999. That's a quadrillion rows in a single table
before you run out of numbers. Access won't hold a quadrillion rows, as far
as I know. So you'll run out of rows in your table before you run out of
numbers if you used a simple numeric sequence. You could still declare as a
15 character text column that held your sequence numbers. If I were you I'd
just use a numeric sequence of my own design. Even if you interated by ten
you'd still have over 100 billion numbers--plenty.
<ma**@1320am.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
Greetings:
I appoligize if I'm asking a question that's already been answered in
the group - I've scoured for about two hours and I can't find a
solution. I also appoligize if I over complicate my question, but I
want to be sure that I communicate my thought(s).