How to add text data from records

[er_manojbisht]

in a query


group by ,sum,avg......are available
is there any way to add text data


suppose i have 3 records having a field [Country name]
France
Japan
Spain

Resulted field=France Japan Spain

Particular records to be grouped may be decided by another field
Suppose a table having field continent and country name
in a query it is grouped by continent then all the country in that continent should be joined like above said


one more thing, is it possible to select a value in list by default?

[jbarrum]

you will need to be more specefic with what you are trying to do. What if the table has 10,000 records. Does the result field need to only result three records and if so how will it know which three?

[er_manojbisht]

Thanks i have solved

[jbarrum]

great! Please mark this thread as "resolved"