Invoice Append

[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

I have tried this solution suggested by Karl Dewey, which appends a number
on the the string, but does the same for the next dispatched invoice:

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

I needs a way to know what the last appended character/number and add the
next in sequence. (The invoice number is auto number)

Setup is SQL 2005 BE with Access 2007 FE

Many thanks
Lez

 

[Clifford Bass]

Hi Lez,

Reply posted to your other posting in the Queries forum. Please do not
post in more than one forum. Or if you really think you need to, make use of
the cross-posting option (Advanced Options) link in the post/reply window.
That way replies will appear in all forums and you will not waste people's
time who do not know that you posted and received a reply elsewhere.

Clifford Bass