Apologies in advance if this is the wrong board to post this under (it was 50/50) and I'm leaning toward the problem being with the macro end of the problem...
I have a Query set up which select records based on an inital criteria being met, then sorts the 8 fields of the records selected into ascending order (based on 4 of the fields).
The Query works fine, the records are ordered by the 1st field, then within that order by the 2nd field value, then within… etc. Just what I need and how I need it, no problems there.
This Query is then part of a Macro, which when invoked saves the results of the Query to an Excel 97-2003 format spreadsheet file.
However when I view the spreadsheet all the required data is there but only sorted ascending by a single field. All the rest of the ‘nested’ sorting has got lost in translation somewhere…
Can anyone offer some advice on this please?
I have a Query set up which select records based on an inital criteria being met, then sorts the 8 fields of the records selected into ascending order (based on 4 of the fields).
The Query works fine, the records are ordered by the 1st field, then within that order by the 2nd field value, then within… etc. Just what I need and how I need it, no problems there.
This Query is then part of a Macro, which when invoked saves the results of the Query to an Excel 97-2003 format spreadsheet file.
However when I view the spreadsheet all the required data is there but only sorted ascending by a single field. All the rest of the ‘nested’ sorting has got lost in translation somewhere…
Can anyone offer some advice on this please?