I used VBA to load data into access table.
I created a complex query that manipulate the table into forms that I want.
I use VBA to export this query back onto a desktop in excel sheet.
After doing that, the query SQL code in the query is gone.
When I click to open the query, it says: Query must have at least one destination field.
Not sure if I should post this in the query section or the VBA.
Please advise !