query that returns one number into a variable

[DSburgh]

I have a query returns a single integer that I need to assignt put into a variable.

This doesn't work:
intCurrentUnits = [qry_sum_units_per_com]![SumOfComp_Units_Per_Component]

I have a list box that displays the query also, would it be possible to use CInt() to pull the value from there? I'm sure it's possible but I keep getting 'invalid use of null' error.

 

[DSburgh]

Silly me, i was using .Value instead of .Column(0,0)

Got it working now

 

[jebry]

Hi!

You can use DLookup:

intCurrentUnits = DLookup([SumOfComp_Units_Per_Component], [qry_sum_units_per_com])

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst