storing results of a query into a variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to store the results of a query into a variable in Access VBA, but i'm
having trouble with the function. This is a sample of the code

Dim x as integer

x = Docmd.openquery("select Query")

The query should return a number
Thanks
 
Take a look at DLookup function and use that instead:

Dim x As Integer
x = DLookup("FieldName", "table/query name")
 
You must log in or register to reply here.

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

Beginner question - getting the values of a query into two variables 1
Access Print Files from Query Results 0
Run 2nd query using results from 1st query 0
Evaluate query results 10
how to pass a parameter to a query base of a query that is the base of a report 0
Inserting Variable into SQL 7
Using a Variable as a query Expression Value 2
Outputting multiple query results as VB variables 7

Back
Top