ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Minimum DatePicker (https://www.excelbanter.com/excel-programming/360588-minimum-datepicker.html)

Wendell A. Clark

Minimum DatePicker
 
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




All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com