Using TransferText to export to CSV file from Access: Fields over 255 Characters are truncated

[Gicu]

You save the totals (group by) query as a saved query (qryMyCombinedUniqueData) then create a new append query based on it:
SELECT INTO .... SELECT * FROM qryMyCombinedUniqueData;

Cheers,