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.
Novice
Windows 7 64bit 
Access 2010 64bit
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.
Who is John Galt?
Windows XP Access 2007
I don't use macros, but I would think you could set a TempVar to a DMax() function.
embededed macro "Date() function" returns 12/30/1899 not system date
getting Object variable or With block variable not set on ODBC code in Access
Posting Permissions
Reply With Quote