will this have 5 columns in the final or are the two finds overlapped:
records with 1, 2, 3 (in first find)
records with 3, 4, 5 (in second find)
Thanks for your reply. I'm not a native speaker so bare with me...
The final excel file will have 3 columns with in the first rows (depending on how many records qualified to the search) the values from 1, 2, 3 and in the following rows the values from 3,4,5. So the data from field 5 for instance will be placed in the third column.
It may be worth investigating creating a new 'Export' table, with three fields in it. Your two finds would be used to provide the data source for importing data into the Export table, mapping the fields accordingly. You would then be left with a new set of records with the data residing in these three fields. Then export this data.
As long as each of the finds always populates each of the three 'new' fields you should be left with a set of data to export without any empty data in any of the fields.
Worth a thought maybe?
Yes, I've been pondering this as well and believe I was trying to come up with some sort of virtual list/table using the two different finds and then pushing values into the correct columns. This would be exportable.
That or ExecuteSQL (with UNION of the two different finds) and the contents of the field would need to be exported in a way to make .csv or .tab/.txt (tab-delimited) that Excel could open.
Ok... Thanks! I was hoping you wouldn't say "coming up with some sort of virtual list"...
I think i will keep exporting three different excels files and copy and paste them by hand t one file...