Concatenating Records

[tinker]

Hiya, Is it possible to Concatenate fields of a report onto one line for example.

If for example a table has the following records

ID Hotel
1 Burj Al Arab
2 Cobblers Cove


Would it be possible to display these records on the same line in a report. e.g

Hotels
Burj Al Arab,Cobblers Cove

Thanks

 

[KKilfoil]

try: http://www.access-programmers.co.uk/ubb/Forum1/HTML/005183.html

 

[lynn_victoria]

Yes you can concatenate fields…. In the report…insert a control box…right click got to properties…click on Control source… click on the three dots to open the expression builder…
Then type
In your field names…like so….

=[FirstName] & " " & [LastName]
with FirstName and LastName being an example of your field names.