I have this code in SAS which read a record that has 15 msg columns
MSG0 - MSG15. In SAS I can use the following code to generate an output line for each message,
ARRAY EditsArray MSGNO1 - MSGNO15;
Do x = 1 to 15;
Edit = EditsArray[x];
If Edit ~= " " then OUTPUT;
Drop x MSGNO1 - MSGNO15;
Is there a way to do this in VBA. I would like to use this in ACCESS if possible.