var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Set variable to query result.
Help! My Access must be a bit rusty, here.
I'm trying to set a variable to the return value of a query statement, and I can't remember the syntax. Here is what I have:
Set ReturnValue = DoCmd.RunSQL("SELECT TOP 1 CheckTypes.CheckTypeID FROM CheckTypes ORDER BY CheckTypes.CheckType;")
...but the DoCmd won't compile, so this is obviously incorrect. I'm sure the answer is simple, but I appreciate any help you can give me.
Yes. RunSQL requires an ACTION query ...
Originally Posted by blindman
So what is the correct method of assigning a query result to a variable?