Adding a footer in Excel when exporting from a form

[Guest]

I have a form that exports a query to Excel. The user clicks on a button and it automatically exports the query to Excel

I want to add a footer to that query when it exports to Excel

Is it possible to do this? If so, what code would I need to use

Thanks in advance
Matt

 

[Lynn Trapp]

Create a report based on your query and export the report to Excel.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I have a form that exports a query to Excel. The user clicks on a button

and it automatically exports the query to Excel.

 

[Guest]

Hi Lynn

Thanks for your response

Is it possible to do it using code within the form? I still want it to be a query that is exported to Excel instead of an actual report

Thanks
Matt

 

[Lynn Trapp]

Not any way that I'm aware of. A query can't create the summary information
that you want. Only a report can.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Hi Lynn,

Thanks for your response.

Is it possible to do it using code within the form? I still want it to be

a query that is exported to Excel instead of an actual report.