Hi guys,
Work have asked for a lot of information to be run from Access and exported into Excel. The info they require will need to be exported into 4 Excel worksheets in the same workbook. Is it possible to tell Access that when they click on the report button on the form, it will automatically run the various queries and then put them into separate worksheets in the same book? I think this is perhaps too complex for Access to do?
Thanks for any suggestions!
Jim
Work have asked for a lot of information to be run from Access and exported into Excel. The info they require will need to be exported into 4 Excel worksheets in the same workbook. Is it possible to tell Access that when they click on the report button on the form, it will automatically run the various queries and then put them into separate worksheets in the same book? I think this is perhaps too complex for Access to do?
Thanks for any suggestions!
Jim