MS-Access: tricky autonumbering

I want to make an access database for handling invoices. The invoice should have an INVOICE_ID (perhaps the primary key) in the following format...

02-BRA005-001
...where...
"02" (first two digits) is the invoice year
"BRA005" is the first 3 letters of a surname and then the clientID (autonumber) for the client
001 (last 3 digits) is kind of like the primary key for "this invoice "

...but there's a catch. When the year rolls over (from 02 to 03 for example) I want the last three digits to reset themselves back to 000 for the next invoice of the new year, for any given client.

Therefore, if I make invoices every three months (roughly), they should have an auto code attached (perhaps the primary key for the invoice) like so...

==========================================
Invoices for Jone Braspire (clientID: 005)
02-BRA005-001 (this is for January 2002)
02-BRA005-002 (this is for March 2002)
02-BRA005-003 (this is for July 2002)
02-BRA005-004 (this is for November 2002)
03-BRA005-001 (this is for February 2003)
03-BRA005-002 (this is for May 2003)
03-BRA005-003 (this is for August 2003)
03-BRA005-004 (this is for December 2003)

Invoices for Rachel Matthews (clientID: 007)
02-MAT007-001 (this is for January 2002)
02-MAT007-002 (this is for March 2002)
02-MAT007-003 (this is for July 2002)
02-MAT007-004 (this is for November 2002)
03-MAT007-001 (this is for February 2003)
03-MAT007-002 (this is for May 2003)
03-MAT007-003 (this is for August 2003)
03-MAT007-004 (this is for December 2003)
==========================================

See the pattern? Looks simple on paper but I'm a newbie (using "SAM's Teach Yourself Access 97 in 24 hours" as a reference, although I'm really using Access 2000) and I can't figure how to make autonumbers in a repeating sequence like this (last digits refreshing themselves accoring to rollover of the first digits).

...come to think of it, I don't even knowhow to make "3" display as "003" in part of the ID code.

Of course, each invoice will have dosens of transactions in a one-to-many subtable. Hopefully I will be able to do this and still maintain an ongoing record of "Invoice history ".

Help appreciated.

 

See if any of these help .

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html
http://www.intelinfo.com/office.html#access
http://www.cof.orst.edu/net/software/dbase/access/running1.sht#idm
http://www.cof.orst.edu/net/software/dbase/access/forms.sht
http://www.free-ed.net/fr03/lfc/course 030101_04/index.html
http://www.rselby.com/Forms.html
http://www.allexperts.com/getExpert.asp?Category=1440

 

I'm not scared of RTFM, so thanks heaps for all those links! Around here no one's really into Access that much except for businesses who place huge prices on anything, but my friend doesn't have any more money to spend on them (thou$ands gone already), and I could certainly do with the upskilling if I'm to help her. Hopefully those courses might have the answers I'm seeking

Thanks heaps.