Invoicing in access

[Switchwork]

Hello I want to assign each job done for every customer an Invoice Number. However I am not sure how to go about doing that??

The problem I am having is obviously I don't want duplicates. One invoice number for one invoice each month.
However there may be a number of jobs to go on that invoice so they will have the same invoice number.

How do I go about doing this??
The beginning of the invoice number changes depending on what month it is.

So when I enter each job should I enter an invoice number for each job but then they will loads the same.

I just can't see a way a round this.
So could someone please help me with this.
I bet its really simple but I just can't see how I can do it without having to retype the same thing over and over again.
Unless I do an invoiceNumbers table and enter all the invoice numbers for every month of the year. Would that work??

Do you think that would work??? Please someone let me know what ideas you have for this as it really is doing my head in.

Thank you
Switch


PLEASE PLEASE HELP ME, HELP ME, HELP MEEEEEE!!!!!

 

[llkhoutx]

I do a considerable amount of invoicing and never generate an invoice number until the invoice is actually generated. There's absolutely no necessity in doing otherwise.

Many things can happen to a "job" before it's completed, associating an invoice with a job or collection of job makes doesn't even pass the smell test.

I recommend that you rethink your approach.

 

[Switchwork]

Thank you for that mate. That is exactly what I was thinking. As in my business (Courier service) anything can happen to the job.

Have you any idea how I can go about assigning an invoice number to an invoice then??

I already have a database running that I designed first (i done it to see what else could be needed)so this one is just a tester sort of thing ya get me??

I am actually invoicing from it so the reports are already designed, generated from a parameter query..

However I didn't think about the invoice number when I designed it so I put in a label with Invoice No. in it that I change in design view each time I do a different invoice..

I am in the middle of designing the PROPER database and don't want to have to do the Invoice No. this way as it is a bit tedious and mistakes are gonna be made changing it manually for each invoice.

So have you any ideas on how I can go about doing this?? I would really appreciate your help as you sound like you know what your talking about??

Please help me I would be most grateful
THANX

SWITCH

 

[Rich]

An Autonumber is the easiest way, though you might have problems with missing numbers, so DMax +1 is the best way, search here for examples

 

[Switchwork]

Thank you for that I have never heard of Dmax+1 but just now when I was doing a search on this forum with the keyword "Invoice" I saw a few posts with that Dmax+1 thing on them. I don't know what it is all about though.

Is there any posts here explaining what Dmax+1 is all about??

I just haven't come across it any of the Access books or Access websites I have looked at. So if you know of anywhere to get an explaination about Dmax from could you let me know???

Thanx in advance.

Much appreciate it if you could let me know if there is any posts relating to Dmax or any where I can get any information about it

Thanx again.!!!!