Need help on Auto Invoice Numbering with Prefix

[calvinyoo]

Hi Everyone,

I'm Calvin, newbie here, just draft our small business database. As topic mentioned, I urged for your help to explain how could let me get auto invoice number.... like press Button or combo box??

Here we got some related info:
10 customers, each I'd like to get invoice number with their own prefix, example ICP, CUC and etc...
Then, I would like numbering to be incremental from each customer, mean: CUC001, CUC002, then, ICP001, CUC003 and so on...

My headache is when I need to put these invoice number into Data Entry table which like below:
Load Date>>Customer>>Particular>>Quantity>>invoice No
1/Jan/2014>>ICP>>part A>>100>>ICP001
3/Jan/2014>>ICP>>part B>>200>>ICP001
5/Jan/2014>>CUC>>part C>>50>>CUC001
18/Jan/2014>>CUC>>part B>>200>>CUC001
23/Jan/2014>>ICP>>part C>>50>>ICP001

I could not use 'Auto Numbering' for each line, as I need out some lines accumulated for one invoice number 'ICP001'.

My questions:
1. What can I do to let me Automatic generate invoice number which increment from last number?
2. What can I do to let me easy to put those 'invoice number' into my Data Entry table's invoice number field? (p/s: Append Query? Update Query?)
3. What if I need sorting (example to group ONE customer and ONE Particular) for my invoicing number? What I meant is ... let say there is 30 lines customer CUC with particular Part B in a same month, and I wanna get them into same invoice number.

Millions Thanks in advance!!!

 

[Uncle Gizmo]

The normal way to do this is to use the Microsoft Access automatic numbering facility for the management of your code and use your own numbering system in a separate field.

 

[Uncle Gizmo]

>>>1. What can I do to let me Automatic generate invoice number which increment from last number?<<<
This is usually done by using the d max function to find the last highest value and add 1 to it. You should be able to find examples of this by searching the forum as it is a frequently asked question.

 

[calvinyoo]

Hi Uncle Gizmo,

Much appreciate your help! Will try to search DMAX and others in forum. Thank you very much.