1 Attachment(s)
VBA to split lines based on fields in table
Hello,
I have a database that contains a table of orders - some of which need to be invoiced in installments and are differentiated as such by the 'number of installments column
If the order is to be invoiced in installments i need to split the order into multiple rows based on number of installments (eg 12 installments = 12 rows,6 installments = 6 rows) and also ensure that these newly created row contain the right 'installment amount' & 'installment posting date' for that installment from the source file
I've uploaded a database with a sample input file and how i'd like the output to look like.
Is this possible to do in Access? I've seen something similar done via record sets but not quite like this
Cheers,
Tom