Search results

  1. E

    n period moving average in queries

    Thank you for your second set of eyes! I was super careful about the field names but missed that. It works!
  2. E

    n period moving average in queries

    Hey DHookom, I get your point about deleted records. In this case, I just imported this stock data so the Rank and the ID fields are identical. My query on the table SELECT ID, close, (SELECT(sum(close) from VIX_DailyHist where ID BETWEEN b.ID and b.ID-4)/ iif(ID > 5, 5, ID) AS VIXSMA5 FROM...
  3. E

    n period moving average in queries

    Follow up question to this answer: If my table already has an autonumber ID field that is properly ordered starting from 1 to N, can't I skip the qryRankRecords and just do the second query directly from the table? I tried it and had troubles with this idea. Cheers, Eric
  4. E

    creating a histogram query

    Years later, thank you for this. I tried a lot of other googled ideas, but none of them worked. Yours does!
Back
Top Bottom