advanced execution of a query in ms-access in VBA code

Question

My current VBA code is exporting my query to csv.

For quantity field, query criteria is [QuantityOrderedOriginal]-[QuantityShipped]-[QuantityBackordered]

Is there aynway in my VBA code, when the [QuantityBackordered] is not 0, import the [QuantityBackordered] field value instead?

look at using IF in the query msdn.microsoft.com/en-GB/library/ms182717.aspx or IIF in access msdn.microsoft.com/en-us/library/27ydhh0d(v=vs.90).aspx — Nathan_Sav
– Nathan_Sav, Commented Jan 9, 2017 at 19:09

Mathieu Guindon · Accepted Answer · 2017-01-09 19:24:49Z

0

Mathieu Guindon

71.5k8 gold badges113 silver badges250 bronze badges

answered Jan 9, 2017 at 19:15

Nathan_Sav

8,5762 gold badges18 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1