query to calculate a 20 moving average

[Bob M]

Hi



I have the following query:-

SELECT time AS "Datetime",
cprice AS "Close_EURUSD",
AVG(cprice) OVER (ORDER BY day ROWS BETWEEN 19 PRECEDING AND 0 FOLLOWING)::FLOAT AS "20-Minute Moving Average"
FROM Z200418
ORDER BY 1 DESC

I get a syntax error (missing operator in expression - the 3rd line commencing AVG(cprice) with the word OVER highlighted

where am I going wrong ?
Bob M

[ranman256]

access sql does not use OVER.
use the query designer, it wont make errors.

[orange]

See the SOLVED post in the Similar Threads at the bottom of the page.