Hi
I have two tables; tbl_site and tbl_item. There is a link between the two tables, Site_ID, in such a way that several items can be links to one site. What I am hoping to achieve is to create a query that displays the site (and a few other fields, but I got those covered I believe) and the linked items - but instead of having a row for each item I would like to combine them so that it displays: "item1 and item2 and item3" or "item1 and item2" (there could be 1 or more item per site).
item field to display is called: "Item_Ref"
Is this possible to do and if so is there anyone out there that might know how to do it?
TIA