Using Access Queries in Excel

[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

 

[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".

 

[Lynn Trapp]

Use Microsoft Query to pull the data into Excel and chart it.