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!