I discovered some interesting behaviour this weekend concerning views. I have a parameterized view that does an averaging of weekly records to a monthly amount. I needed another view that did a sum of this data for a selected period of months. I created this view and it worked.

I found, though, that a requery of the SUM view did not produce the correct results for subsequently selected periods. I found that it only worked correct on the first select when all the tables and views were first opened. In order to get the correct behaviour I needed to do an explicit REQUERY of the underlying AVERAGE view first and then the REQUERY of my SUM view.

It seems that if a view is based on a view, when you requery a view it uses the existing values in the underlying view and does not requery it based on any changed parameters or values.