List Details Horizontally

[ggj13557]

Uncle Gizmo posted a response to Ziggy1 back in August about this same topic but I can't make it work in my database for some reason. I suspect it's because I am using Access 2002

I have attached the .mdb and hope someone can explain how to make the IP Addresses in the report details display horizontally and not vertically while keeping the sorts the same. Any suggestions would be greatly appreciated!

Uncle Gizmo suggested a function that worked within the query but the function kept bombing on the "Dim DB As DAO.Database".

Thanks in advance,
~ Greg

 

[KenHigg]

Would something like the following work:

Link

???
kh

 

[ggj13557]

Ken,

I didn't see a report in the DB you attached. My query looks a lot like yours but I want to (using your example) create a report grouped on Client ID and lists the Med Descriptions horizontally vice vertically for each Client ID.

Thanks
~ Greg

 

[KenHigg]

Yeah - This is the only way I could figure out how to do it. The drill is to get all the fld values together in a single field for each of the key values. To do this I had to do a temp table, populate it and use it in the report.

I would like to see if anyone else has an easier way to do this...

kh

 

[ggj13557]

Uncle Gizmo has the solution to this problem but I can't make it work with my database or version of Access. Here it is if you want to take a look.

http://www.access-programmers.co.uk/forums/showthread.php?t=71302

~ Greg

 

[KenHigg]

Cool - I see how it works but I'll wait and see if Giz replies...

kh