Expression across rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone provide information about writing expression across rows?

An example is I have some data in Field1 (say 200 records). I would like to write an expression that returns a moving average of n days (parameter) when the qurey is run.
Also what are the overheads involved in this. Am I better off retriving the data to excel and calculating with spreadsheet functions.

Any info appreciated

Bruce
 
Can anyone provide information about writing expression across rows?

An example is I have some data in Field1 (say 200 records). I would like to write an expression that returns a moving average of n days (parameter) when the qurey is run.

You'ld need to use the DAvg() function with criteria to select the
desired records.
Also what are the overheads involved in this. Am I better off retriving the data to excel and calculating with spreadsheet functions.

The overheads can be substantial, since the query must call the rather
expensive DAvg() once for every row. This may be better in Excel!
 
Back
Top