Combining multiple records into one memo field

Hello,

What I want to do seems simple enough, but I can't seem to find a simple
answer. go figure.

I have a table that has records of different leinholders. I want to take the
leinholder names based off of certian criteria and combine them into one memo
field.

example:

Lienholder
Doe Jane
Doe John

to
Doe Jane, Doe John

This has nothing to do with database structure. I need to utilize as much
space on a report page as possible. I first though of using columns in the
detail section of the report, but the leinholder names can get qiute lengthy
and fields cannot grow left to right, only up and down and I can't leave off
any part of the name. If I combine all the names together in one memo field
and have it grow as needed, best utilizes as much space as possible on the
report

I looked at some of the posts that already exist on various versions on this
subject and cant seem to find a working solution. Does anyone have any ideas?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1

On Thu, 06 May 2010 17:04:57 GMT, "vander via AccessMonster.com" u59668@uwe
wrote:

I have a table that has records of different leinholders. I want to take the
leinholder names based off of certian criteria and combine them into one memo
field.

example:

Lienholder
Doe Jane
Doe John

to
Doe Jane, Doe John

See http://www.mvps.org/access/modules/mdl0004.htm for VBA code to do this.
--

John W. Vinson [MVP]

Hi John,

Ive pasted the code into a new module, then I pasted the function into a
query. Problem is when I try and save the query I get a "The SELECT statement
includes a reserved word or an argument name that is misspelled or missing,
or the punctuation is incorrect."

John W. Vinson wrote:
I have a table that has records of different leinholders. I want to take the
leinholder names based off of certian criteria and combine them into one memo
[quoted text clipped - 8 lines]
to
Doe Jane, Doe John

See http://www.mvps.org/access/modules/mdl0004.htm for VBA code to do this.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1

On Fri, 07 May 2010 19:23:08 GMT, "vander via AccessMonster.com" u59668@uwe
wrote:

Hi John,

Ive pasted the code into a new module, then I pasted the function into a
query. Problem is when I try and save the query I get a "The SELECT statement
includes a reserved word or an argument name that is misspelled or missing,
or the punctuation is incorrect."

Then correct the error in the SELECT statement.

If you would like help doing so please copy and paste the SQL view to a
message here, so someone can see it to help you.
--

John W. Vinson [MVP]

The problem is I dont see anything wrong with it. I copied exactly as it
shows in the example you pointed me to.
So obviously that Select statement you pointed me to is wrong.

John W. Vinson wrote:
Hi John,

Ive pasted the code into a new module, then I pasted the function into a
query. Problem is when I try and save the query I get a "The SELECT statement
includes a reserved word or an argument name that is misspelled or missing,
or the punctuation is incorrect."

Then correct the error in the SELECT statement.

If you would like help doing so please copy and paste the SQL view to a
message here, so someone can see it to help you.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1

On Tue, 11 May 2010 16:30:07 GMT, "vander via AccessMonster.com" u59668@uwe
wrote:

The problem is I dont see anything wrong with it. I copied exactly as it
shows in the example you pointed me to.
So obviously that Select statement you pointed me to is wrong.

Sorry.

I'll try to help if you allow me to do so. I cannot see what you did, so I'm
unable to help. If there are no errors, and you adapted the code to the
tablenames and fieldnames of your database, then I have no idea what might be
wrong.
--

John W. Vinson [MVP]