Assign query results to variable? (ACC97)

K

Kyle [EAS]

Hello! I've got a select query that returns a single field. Is it possible
for me to assign the result of this query to a variable? Something like
this:

var = query.query_result

Thanks!
 
D

Dirk Goldgar

Kyle said:
Hello! I've got a select query that returns a single field. Is it
possible for me to assign the result of this query to a variable?
Something like this:

var = query.query_result
Click to expand...

Use DLookup. The first argument would be the name of the field returned
by the query, and the second argument would be the name of the query.
For example,

var = DLookup("ResultField", "MyQuery")
 

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

Assign Formatted Block of Text to Theme 0
Use a variable in a ShapeRange.Increment 0
Request Form - Alert Team Member 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Incorporating the User Profile location into a document template path 1
Assign Selection to a Variable 2

Top