I have two parts to this question:
1. How can I export my query to Excel when the user clicks on the link to the page with the query in it.
2. Is it possible to not have to list all the fields in the query for the output on the query page?
I Have some simple reports to do. The table has probably about 40 fields.
I do not want to list the query and then list all the fields in the query for output.
I want to do the list of the query results dynamically.