Retrieve result from query

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Assign Query Result to variable 2
Retrieving a single value from a table 1
Problem filtering and opening a report 1
Pass the results of a query to a variable 1
How to retrieve a query result to variable? 1
set parameter to a query 1
Getting Query result into VB variable 3

Top