input box with result from query in access 2010

bill201
bill201 used Ask the Experts™
on
hi

do it's possbile to get the result of a query into a input box

for example
i have a query that the result is like this
the field name "price":
75
150
200

and i want that the input box will be like this "the customer prices are 75,150,200

do it's possible at all?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
MIS Liason
Most Valuable Expert 2012
Commented:
Sure, but why not display it in a textbox.
(ths way it is always visible, can be copied/Pasted, and used elsewhere, ...etc)

Remember that if you close the message box, the total is gone.

Also remember that you should be calucalting this total somewhere already, this way you just display the total.


In other words can you first explain what you are trying to do abnd why, in case this is not the most efficient method...

;-)

JeffCoachman
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
...and also post the design/structure of the source data

Author

Commented:
ok i think that it's good for me to make a text box
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
OK

;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial