V
vander via AccessMonster.com
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?
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?