Using a query variable in code

[DJT1]

What I want to do is use a variable from a select query to label an Excel worksheet I want to export to. The variable is Collected by a standard select query without the use of VBA Code. I would think this isn't possible unless the variable for the query was obtained via VBA code. I was hoping someone would be able to give me a difinative answer one way or the other.

Thanks.

 

[PHV]

use a variable from a select query
Take a look at the DLookUp VBA function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244