Hi I have two recordsets X and Y
X is the basic recordset, items in Y are retrieved with another recordset.
Some of the data in Y has to be combined(added field) with values from recordset X. If a certain record in X is 0 some data from Y has to be retrieved. What is the best way to do this in the recordset itself or in an array. Output of recordst or array has to go to Excel.
I hope this question is clear to you?