batch despatch invoice

[Lez]

Hi Guys,

I have an got an invoice application and want to be able to part dispatch
items and append a letter to each invoice , so for each dispatch I can
append a letter to the end of the invoice.

The situation is this:

An order invoice is raised for 6 items.

The order is to be completed in 3 shipments, so the first invoice would go
out with 1001A
Next items ship invoice would be 1001B
Final shipment is done invoice is 1001C

Naturally would want to reuse the append characters

Setup is SQL 2005 BE with Access 2007 FE

Many thanks
Lez

 

[KARL DEWEY]

Try this --
Left([ship invoice], 4) & Chr(Asc(Right([ship invoice], 1))+1)