This is a 2 hours job.
I have a Pivot table that reads data from a Access database. There are 2 fields I need to filter in MS query.
User will fill 2 values in a form you will provide "Initial date" (Date1) and "Final date"(date2).
You have to apply those values to the query. Something like Initialdate>= date1 and finaldate<=date2
User will provide the date in dd/mm/aaaa format.
Default value will be provided (01/01/1980 and 31/12/2099).
This will run in Excel XP.
I will provide the macro to create the Pivot table, so you have to create a form and add the 2 values to the query.
You must apply the filters to the PT selected. So if there is no PT selected, display a message.
4 freelancers are bidding on average $40 for this job
Hi , I can finish this project in less than a day..few [url removed, login to view] only think that i would need is a test databease , so i can test the sql querry on it . Br Dragoshs