Using Access Queries in Excel

S

Steve Haack

All,
I have a lot of data in access, and I have built a sample query to get the
data summary that I want.

I also have a chart in Excel that charts the data.

What I would like to do, is allow the user to select a data range, for
example and have the query be changed to select the dates chosen.

How do I do that from Excel? Can someone point me to information on this?

Thanks,
Steve
 
D

Dorian

Why not do the charting in Access?
It's much simpler to do all the work in one application.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

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

Creating a Chart on form from selected data in query. 0
Embed the same Excel multiple times 0
Need Help with a VBA subroutine 0
query to show where no data in a stated column 0
Linking data in MS Word into Excel 5
Access Query to import from Sharepoint 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
anchoring text boxes to line charts 0

Top