Exporting a date range of information from Access to Excel

F

Frustrated Bob

I have an Access database field that contains the name of a part, which is
one of 93 parts. I want to be able to export this data to Excel so that I
can statistically show the numbers of each type of part sold within a
specific time frame. For instance, we sold 25 widgets last quarter which is a
15% increase over the previous quarter. The exported data would go to Excel,
be broken down by part name, and then converted to a pie chart. I think I
know how to limit the time frame in Access, but am lost when it comes to
exporting the data and generating the statistics in Excel and creating the
pie chart. Any help would be appreciated. I will also post this in the
Excel Discussion groups
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
Integrating information from Word to Excel (not mail merge) 1
VBA - exporting serial letters to single documents 0
Importing data from Access and creating statistics and a pie chart 1
Insert name and adress from a list in a word document 1
Create a chart from a table in word thats dynamic 0
Autonumber field in Excel that behaves the same as Access 0
Embed the same Excel multiple times 0

Top