How can I get a SQL that returns a single value (using Max for example) into a variable in Macro. I would like to use that value further down the line.
How can I get a SQL that returns a single value (using Max for example) into a variable in Macro. I would like to use that value further down the line.
I don't use macros, but I would think you could set a TempVar to a DMax() function.