CurYearWeekEnd is the selected value from the filter - this is a field in the table and is equivalent to weekend(SCSDAT)
SCPAX is the field I want sum of.
The weekly table gets refreshed on change of the week selection
However the 2 other tables which are for month and year don't refresh with the new selection. However if I open and edit the table and change the formula (rather re-save) then the table gets refreshed and correct values are displayed
Anyway for refreshing the other 2 tables automatically? Is there a refresh command?