displaying records horizontally

[Hanjo]

If you have a one - many relationship between data, normally in the table it is captured, you would find multiple rows for every 'thing', each row detailing different 'functions' performed on it.

Is there a way that one can display these functions horizontally, instead of vertically, i.e, have one row per 'thing', instead of multiple rows.

it's just a principle question, is it possible, and how. thank you.

 

[jdraw]

You could review Allen Browne's func concat to see if it will work for you.
http://allenbrowne.com/func-concat.html

 

[Hanjo]

Thanks, unfortunately it seems like the Concatenate function will only work for very simplistic data.

most example cases are 1 company name - many order dates.

my issue is that I have 1 property - many processes. but the processes are quite elaborate. I would have a 'type' field, a value field, a category field and a year field, specific to every process.

it looks something like this

10 Benoni - GV 10 000 residential 2013
10 Benoni -OBJ 5 000 Vacant 2013
10 Benoni - 78 5 000 residential 2013

Now to get data to that extent in one line, horizontally displayed, seems near impossible.

 

[Libre]

Have you tried a pivot table?
From your description, this is exactly what it does.
Hard to set up, I've found - and I've found the pivot function in Excel to be superior to the one in Access. But from your description, I would take a look at this function.