Forum Discussion

manny213's avatar
manny213
Copper Contributor
Nov 01, 2021

MS Access SQL - No Current Record Error

Hi I am getting this error when I run a query below query:   SELECT *, (SELECT STDEV(LOG_PRICE_CHANGE) FROM QRY_LOG_PRICE_CHANGES AS T1 WHERE T1.UNDERLYING_SYMBOL = QRY_LOG_PRICE_CHANGES.UNDER...
access
manny213's avatar
manny213
Copper Contributor
Nov 02, 2021

manny213 

Hi

Is anyone able to help me with this?

Thank you

  • isladogs's avatar
    isladogs
    MVP
    Nov 02, 2021

    Does the subquery work as a standalone query?

     

    You can find various timeout settings in Access options.. Client Settings....Advanced

     

     

    • manny213's avatar
      manny213
      Copper Contributor
      Nov 02, 2021
      Thanks for the reply.

      Yes the base query QRY_LOG_PRICE_CHANGES runs fine on its own.

      I took a look at the Client Settings...Advanced options. There are 5 settings. Which one would you suggest I look at?
      • isladogs's avatar
        isladogs
        MVP
        Nov 02, 2021

        manny213 

        That wasn't my question. This is the subquery:

        SELECT STDEV(LOG_PRICE_CHANGE)
FROM QRY_LOG_PRICE_CHANGES AS T1
WHERE T1.UNDERLYING_SYMBOL = QRY_LOG_PRICE_CHANGES.UNDERLYING_SYMBOL AND
QRY_LOG_PRICE_CHANGES.ROW_NUMBER-T1.ROW_NUMBER BETWEEN 0 AND 20

         

        Does that run as a standalone query?

         

        These are my settings:

         

        How do yours differ from those?

         

Resources