I don't think I covered how to do this for existing customers. It would be a little more challenging, probably beyond a TechHelp video. A simple DMAX won't cut it for existing records. Probably best done with a Recordset loop. I'll add it to a Developer class soon.

Hello Richard

Thank you I fought a bad later on and be easy to do it by just putting the numbers in even though there is 400  numbers it shouldn't take too long to type 1 to 400 in is it how many customers I have my business is nothing like yours is this the small home business

Yeah, you can certainly just type them all in. A quick trick would be to use Excel. Type in 1, 2, 3 in rows down. AutoFill it out to 400. Copy and Paste that into Access.

Hello Richard

thank you for your quick response I thought it would be that way I'll just type the numbers in of got plenty of time today so I will do that way this way you get that working in the end I used the lesson from 2003 which I sent the link to you in the previous message did some tests in my test database which is a duplicate of the one that I am actually building thanks for all your support.