Auto increment and set range

[Frank Knox via AccessMonster.com]

I would like to set up a simple sample tracking database. I have a form
with four fields.
RackId, RackNumber, Row and Colmun.
I have RackID set to the day of the week. I would like row to have the
range A-G, and Column to have the range 1-12. I would like the row number
to increment by 1 when the column number reaches 12 ie:
A11, A12, B1, B2 etc. When the G12 is reached I would like the rackNumber
to increment by 1. Is there a simple way to do all this? Any help would be
greatly appreciated.
please reply to fhknox(at)sbcglobal.net

Thank You in advance

 

[Wayne Morgan]

First, how do you want to handle one week from the next? If last Tuesday you
got up to A11, do you want the first one this Tuesday to be A12 or start
from A1 again?

 

[Frank Knox via AccessMonster.com]

Racks will only be kept for 7 days. i will start a new rack then.
Thanks
Frank