Autogenerated Purchase Order Number

[burrina]

A day late and a dollar short, it occurs to me that I need a autogenerated purchase order number.


I would like to use the first letter of the Customer for that Order as the first part of the Purchase Order.
Below is the Combo code I use to get the Customer from.
I would then like to add this code after that first letter has been obtained. I was trying to do this myself but with no luck. Some sort of trim statement is needed I suspect!

So, again, I want to use the First Letter of The Customer Name, i.e. CustomerID and then use the OrderID Plus 20 for a unique PO Number.

=Left([CustomerID],1)+[OrderID]+20


SELECT DISTINCTROW Customers.CustomerID, Customers.CompanyName, Customers.TaxRate, Customers.ShipRate, Customers.CustShipVia FROM Customers ORDER BY Customers.CompanyName;


Hey, I did not use the above but something just as good. Thanks Anyway Guys!

[alansidman]

How about showing a solution for those who may need it for a similar situation at some time.

[burrina]

Here is what I did. I used this as the control source for the Purchase Order Number. Sorry, I should have posted the solution.Was feeling really bad.

="EU" & "" & [OrderID]+5 & "S" & Year(Now())