In Access 2007 in need have one column (Cust Name) and the other (Pet Name). Presently, if a cust has multiple pets, there's a line for each pet. How do I combine all the pets (multiple columns) with the one owner.
In Access 2007 in need have one column (Cust Name) and the other (Pet Name). Presently, if a cust has multiple pets, there's a line for each pet. How do I combine all the pets (multiple columns) with the one owner.
The data is properly saved in normalized structure. If you want a report to show one line, review this http://allenbrowne.com/func-concat.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I guess I'm too dumb to understand the programming string provided. It is what I want to do, but I don't "get" how to do this. Any chance you can simplify this into "layman" (aka-me) format? Appreciate the help, just need more simplification. Sorry
Allen's instructions are explicit enough for anyone having any familiarity with VBA programming. I'm not going to try to instruct you in programming basics. Review http://office.microsoft.com/en-us/ac...010341717.aspx
Here is another thread from just today on this same issue https://www.accessforums.net/showthr...es-Attachments
Last edited by June7; 04-04-2012 at 01:27 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.