Hi All
First time here hope you're all well and someone can help with my problem.
I've created a pricing db that allows our sales staff to price up products and service. This works fine but now the powers that be want to produce customer quotes from this data. Currently the pricing form shows all products in table format as below
Desc Qty Min Sell Correct Sell Margin
Product1 1 £2 £3 10%
Product2 2 £3 £4 15%
Product3 0 £1 £2 8%
Product4 0 £2 £4 10%
When this info is saved I would want Product1 created as a quote line, Product2 as a sepearte quote line but Product3 and Product4 would not be created since they are zero qty. I know i need to write vba to loop through each of the fields to check if qty > 0 but I'm not sure if it is possible to do this for multiple fields on 1 record and then split into multiple records and not sure of the vba.
Would really appreciate any help given.