Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I am sure this is my limited knowledge about Access functionality but,
What would be the proper way to run a procedure to export data from a query in format to which counts and sums are already done? I am sure I will have to employ some VBA to do this. I can Chart the Data just fine with in Access but Excel has way more Chart Formating options and the Modern Charts in Access 2016 do not have the style charts I need to complete the report.
Is there a way to do this?
the query I run takes a table of 1200 records and filters it 66 based on the Year, Supplier code, When it exports is just the table of data itself, not graphable if i just highlight and plop a chart.
With in that year we want to count for example Complaints by Customer
Complaints by product type, how many bad parts per product (seperate query) etc.
obviously Access Chart builder does alot of the math work for you. but in excel i would have to take the table data and run further formulas to create the table needed for the graph. But is there a way to export the data already in that format?
end goal is to make a button on a "Front page" Form to run this procedure and show the graphed data.
What would be the proper way to run a procedure to export data from a query in format to which counts and sums are already done? I am sure I will have to employ some VBA to do this. I can Chart the Data just fine with in Access but Excel has way more Chart Formating options and the Modern Charts in Access 2016 do not have the style charts I need to complete the report.
Is there a way to do this?
the query I run takes a table of 1200 records and filters it 66 based on the Year, Supplier code, When it exports is just the table of data itself, not graphable if i just highlight and plop a chart.
With in that year we want to count for example Complaints by Customer
Complaints by product type, how many bad parts per product (seperate query) etc.
obviously Access Chart builder does alot of the math work for you. but in excel i would have to take the table data and run further formulas to create the table needed for the graph. But is there a way to export the data already in that format?
end goal is to make a button on a "Front page" Form to run this procedure and show the graphed data.
