Return MAX() Value to VBA variable from SQL

[T86157]

I would like to assign and return a Max value from a SQL query to a variable within VBA. Below is the code I am working with at the moment to obtaining this. Not sure if I assigned all variables or if my programming is incorect.

Please Login or Register  to view this content.

Hope the code above helps to see what I'm doing.

Thank you,
Tyler

[Haluk]

I didn't test your code as a whole but, can you try this?

Please Login or Register  to view this content.

.