Recent content by Bob100

Success. Wow learnt a fair bit tonight. learnt where to put sql into a query, and that code above works. final solution turned out as: select "COD" & format(right(max([orderNumber]),4) +1, "0000") AS expr1 From tblorder. Access added [] and AS expr1. Can know populate form field with answer on...

Forgot to thank you all. It must be frustrating for you. Bob.

Have been researching and found the following which I have changed but doesn't work. Select "cod" & format(right(max(ordernumber),4) + 1, "0000") from tblorder Tried this in expression builder in a query but no luck????. Would it work. Can it be put in a query, if so what have I done wrong. If...

Ok. Database made and populated. Building a form to capture order info which I will append to the order table. Only the ordernumber does not increment by 1 when I open the form with a macro. Next value being cod4332. Would like a solution which keeps the field as one. Can the problem be solved...

Sorry all, totally confusing myself now and making toooooo many errors. have approx 5000 records all with sequential COD0001 (missed out a zero). Forget ORD different field and problem. Someone has suggested the following SELECT "COD" & Format(RIGHT(MAX(ordernumber),4) +1, "0000") FROM...

Thanks for your advice. But I already have 5000 records from my boss with the order number already set as COD001. Should I try to remove the letters in excel and work from there? Import as a number and use format to add the "ORD".

Hi MS-2003-I have created a simple customer, order database (4 tables in total) and populated it with 5000 records. The tblorder uses ordernumber as PK which is a text field with data in the form of COD000, COD001. I have now been asked to create an order form where the ordernumber...