Query Of The Day!

[rookery]

Morning,

Is it possible to allocate a variable to a query, call the query and then display the result in a text box? Haven't tried it yet but was looking for any tips....

 

[JoanneM]

Hi there

Are we getting into User defined Types here or are we just thinking about putting a function into a query returning a value and displaying the result in a text box

regards

Jo

 

[rookery]

Thanks for your response Jo but i've figured out how to do it.

 

[EdwardMartinIII]

How did you do that? I've been trying a number of different ways and can't seem to get the darn thing to work.

Thanks,

Edward

 

[rookery]

Hi Ed

I've been searching thru' my project but cant seem to find where I used this anywhere. Perhaps I got rid of it. Sorry.