Hi everyone,
now I have sheet that compares between different data from different tables ... the problem is that each chart done doesn't see the selection made in the filter I have tried more than one way but it doesn't work
so the filters is made using :
Year([MasterCalendarDate.AllDateTime])
Month([MasterCalendarDate.AllDateTime])
Day([MasterCalendarDate.AllDateTime])
the tables on the other hand has the following calculation in it :
(sum (interval ([TechTimeLog.TechStopTime] - [TechTimeLog.TechStartTime])))
note that in
MasterCalendarDate.type = 'TechTimeStart'..................... was created by me in the master Date table so that the dates in the master date table that were pulled from [TechTimeLog.TechStartTime] will have 'TechStartTime ' in front of them in a separate columns
So any suggestions
