Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Access data from Query
0 views
Skip to first unread message
Kucster
Jan 17, 2008, 5:25:12 PM1/17/08
to
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
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
Jan 17, 2008, 6:42:14 PM1/17/08
to
[Variable] = DLookup("[Field]", "DMax")
Kucster
Jan 18, 2008, 10:50:01 AM1/18/08
to
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
0 new messages