I've been trying to construct a dynamic query based off of disparate data
tables one (ACCESS) table covers the team designations with a client start
of service -- a separate (SQL2000) table covers the visit date and work
tracking.

I would like to join the two tables through an excel pivot table showing the
dates of service for the clients, reporting for a particular team.

Their doesn't seem to be a date-picker function in excel-vba that I could
harness -- if their is what is it called.

I tried to utilize the refedit control to return the date(s) - range from
the spread sheet then their seems to be no min() max() functionality to back
feed the query with.

Whats the best way to get this information in a usable format.

--
Wendell