Query that returns a value to variable
 

I am trying to query and accesss database. I can query the database and
return a value to cell on a work sheet, but I would like the value assigned
to variable instead. Can that be done with out placing the value on a
worksheet? I use the value in a formula.

Thanks,

Mike