Dmax (1 Viewer)

Hi, I have an access database. I have 56 customers for which i have a table and a form. I want to create auto invoice number for each customer whenever user add new invoice. I tried DMax auto increment but all in vain. Please help me immediately as I want auto increment for each customer by giving him a specific tax also for example for customer Daniel I want D-01, and in next new invoice i want D-02........... My database information is .......table name in invoicetble.......field name is "invoice" and form name is Invoice_Form.

use the field AUTONUM. It creates number automatically. No programming needed.
You can add a letter in front if you want. (as a calculation)

no.........i want auto number for each customer separately......for example there is ranman then i need ranman-01, and if i have adnan then i need adnan-01...........so it doesnt cover with auto number

This question is double-posted here https://www.access-programmers.co.uk/forums/showthread.php?t=301191 I am not going to delete either as there are responses in both, but please, adnmhz, only ask one question once, in one post. This is common courtesy in forum behavior across the internet.
Thanks in advance,
Mark

First, why? What's so special about these invoices numbers? Do they need to fulfill a purpose other than being unique?

Second, check the 'Similar Threads' section at the bottom of this page. This has been asked, had their purpose questioned and ultimately answered many times on this forum.

Third, if those links don't help, explain in more detail what you are specifically attempting to accomplish this. Post code and where you put that code.