Retrieve result from query

[Kent]

Hi

How can i retrieve the result from a query when using VBA?
I have a query that gives me 1 record, the Max value in a recordset.
I need to rertieve it and store it in a variable.

 

[Alex Dybenko]

Hi,
the easiest way - use DMax() function

MyVar=DMax("myfield","myquery")

see online help for more info

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com