SQL into a labels caption ?

[SpookiePower]

I would like to put the result from an SQL into the caption of a label, but it keeps showing the SQL sentenc insted and not the result. I can see that the label thinks it is some text I want to show, but how can I make it do what I want it to do ?

How I have tryed it -
label.caption ="select.......... ;"

 

[stopher]

Try using the DLOOKUP function instead of SQL.
hth
Chris

 

[khawar]

You have to calculate the value in a variable then you will be able to assign it to label

 

[SpookiePower]

Thanks to both of you