Hi.
My company uses a one-page Excel spreadsheet for calculation of annual salaries by department. A paper copy (!) of the spreadsheet is then submitted (that's a different problem).
My data (for multiple departments)is in an Access database. In a nutshell, how do I get my data to look like the required Excel report?
I tried redrawing the spreadsheet as an Access Report. It was too cumbersome in terms of the design.
I've looked into OLE but don't need to work with the Excel application. I just want my final Access report to look like the required Excel report.
Thks for your help.
Mary Brown
My company uses a one-page Excel spreadsheet for calculation of annual salaries by department. A paper copy (!) of the spreadsheet is then submitted (that's a different problem).
My data (for multiple departments)is in an Access database. In a nutshell, how do I get my data to look like the required Excel report?
I tried redrawing the spreadsheet as an Access Report. It was too cumbersome in terms of the design.
I've looked into OLE but don't need to work with the Excel application. I just want my final Access report to look like the required Excel report.
Thks for your help.
Mary Brown