Access data from Query

[Kucster]

Hello, I just can't seem the solve this seemingly simple problem, so i
ask for your help.
I created a query in design view called Dmax and all it does is find
the largest value in a column and display it. All I want to do is run
the query and return that value so I can use it for some calculations
in VBA in my forum.
Thanks for your help.
-Sean

[Tomac1]

Post by Kucster
Hello, I just can't seem the solve this seemingly simple problem, so i
ask for your help.
I created a query in design view called Dmax and all it does is find
the largest value in a column and display it. All I want to do is run
the query and return that value so I can use it for some calculations
in VBA in my forum.
Thanks for your help.
-Sean

[Variable] = DLookup("[Field]", "DMax")

[Kucster]

Post by Tomac1

Post by Kucster
Hello, I just can't seem the solve this seemingly simple problem, so i
ask for your help.
I created a query in design view called Dmax and all it does is find
the largest value in a column and display it. All I want to do is run
the query and return that value so I can use it for some calculations
in VBA in my forum.
Thanks for your help.
-Sean

[Variable] = DLookup("[Field]", "DMax")

Thanks for the help it worked like a charm, it seems like it's always
the easy problems that hold me up the most.
Thanks for the help
-Sean