Output of query in text-field

[Guest]

Is there anyone who can help me? I would like that the output of a query is
placed in a text field of a table. E.g. the output of a total query shows 3
records as result.I would like to combine these 3 records into one single
text field. How can I accomplish this.The Dutch usergroup did not reply to my
question.

Thanks for any suggestions/solutions.

Ron

 

[tina]

hmm, possibly you got no answer in the other newsgroup because it's not a
good idea. the general rule is: do not store calculated values in a table.
store the raw data, and run the calculations as needed, in a query, form or
report. it's also not good design to store multiple values in one field;
think atomically - one datum, one field in one record. again, you can
combine separate data as needed in a query, form or report.

hth

 

[Guest]

Hi Tina,

In this case itis necessary. I normally do not store data from a query in a
table but the data (from a mainframe system) needs to be cobined into one
single tabel for viewing purposes. The table is filled at the end of the year
and refilled the next year. The data is constant throughout the year. I
understand from your answer that is is possible but could you tell me how>

Ron

 

[Guest]

RoBo,
Could you provide some sample records and how you would like them combined?
Are you hoping to combine values from a single field or multiple fields? How
about providing some significant table and field names?

 

[tina]

don't confuse data storage with data display, hon. you can store the data
properly in a normalized table(s) setup, and display it in a form or report
just about any way you want to. as Duane asked, can we see some sample data
and example(s) of how you want to display it?

hth