paulfenwick
Technical User
Hi, I need a query to find the running average and running Standard Deviation of one of the fields of the last 25 records in a table.
Is this possible?
I though that I could create a query to seqentially number the records (somehow?) then link that to a query that has the criteria (<= No and >No-25) - but is there an eaiser way?
Thanks
Is this possible?
I though that I could create a query to seqentially number the records (somehow?) then link that to a query that has the criteria (<= No and >No-25) - but is there an eaiser way?
Thanks