(Msg. 1) Posted: Thu Jul 24, 2008 6:02 pm
Post subject: displaying records in a report Add to elertz Archived from groups: microsoft>public>access>reports (more info?)
I have a question about a text box in a report. The control source of the
report points to a table and that table has the information like this
usr name id
danny 2001
danny 2002
danny 2003
My report has a header that pulls the user name in and underneath in the
details is the id. Right now the data in the detail section displays in a
carriage return style.
Example.
[Page header] user name id
[usr name header] danny
[detail] 2001
2002
2003
I need to know how i can manipulate the text box to take each detail record
in the table and put it into a format separated by commas, semi colons etc.
So my example would be this,
[Page header] user name id
[usr name header] danny
[detail] 2001, 2002, 2003
My table has many users with multiple id's and I am trying to make the report
look less like a list. If this makes sense, Please let me know what I can do
(Msg. 2) Posted: Thu Jul 24, 2008 6:02 pm
Post subject: Re: displaying records in a report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
den1jxt via AccessMonster.com wrote:
>I have a question about a text box in a report. The control source of the
>report points to a table and that table has the information like this
>
>usr name id
>danny 2001
>danny 2002
>danny 2003
>
>My report has a header that pulls the user name in and underneath in the
>details is the id. Right now the data in the detail section displays in a
>carriage return style.
>
>Example.
>[Page header] user name id
>[usr name header] danny
>[detail] 2001
> 2002
> 2003
>
>I need to know how i can manipulate the text box to take each detail record
>in the table and put it into a format separated by commas, semi colons etc.
>So my example would be this,
>
>[Page header] user name id
>[usr name header] danny
>[detail] 2001, 2002, 2003
>
>My table has many users with multiple id's and I am trying to make the report
>look less like a list. If this makes sense, Please let me know what I can do
(Msg. 3) Posted: Thu Jul 24, 2008 7:27 pm
Post subject: Re: displaying records in a report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
This database is awesome! This will help a lot of other things I do, I just
need to figure out how I am going to use this to pull text driven Id's and
not numbered id's
If you have any suggestions, I would appreciate it.
Thanks again
Marshall Barton wrote:
>>I have a question about a text box in a report. The control source of the
>>report points to a table and that table has the information like this
>[quoted text clipped - 25 lines]
>>My table has many users with multiple id's and I am trying to make the report
>>look less like a list. If this makes sense, Please let me know what I can do
>
>You can use a function to build the comma separated list.
>There's a good one at:
>http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records'
>
>OTOH, if the commas are not critical, you could use a multi
>column subreport to get a similar effect.
>
(Msg. 4) Posted: Thu Jul 24, 2008 11:15 pm
Post subject: Re: displaying records in a report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Presuming you have a table with the ID and text, join it to
the report's record source query (on the ID fields) and use
the text field instead of the ID field.
--
Marsh
MVP [MS Access]
den1jxt via AccessMonster.com wrote:
>This database is awesome! This will help a lot of other things I do, I just
>need to figure out how I am going to use this to pull text driven Id's and
>not numbered id's
>
>
>Marshall Barton wrote:
>>>I have a question about a text box in a report. The control source of the
>>>report points to a table and that table has the information like this
>>[quoted text clipped - 25 lines]
>>>My table has many users with multiple id's and I am trying to make the report
>>>look less like a list. If this makes sense, Please let me know what I can do
>>
>>You can use a function to build the comma separated list.
>>There's a good one at:
>>http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records'
>>
>>OTOH, if the commas are not critical, you could use a multi
>>column subreport to get a similar effect.
>>
(Msg. 5) Posted: Fri Jul 25, 2008 5:15 pm
Post subject: Re: displaying records in a report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I got it all to work and it is great! I am running into an issue of greater
than 255 charaters. Is there a way to specify the charater count? Sort of
like a memo field.
Marshall Barton wrote:
>Presuming you have a table with the ID and text, join it to
>the report's record source query (on the ID fields) and use
>the text field instead of the ID field.
>>This database is awesome! This will help a lot of other things I do, I just
>>need to figure out how I am going to use this to pull text driven Id's and
>[quoted text clipped - 12 lines]
>>>OTOH, if the commas are not critical, you could use a multi
>>>column subreport to get a similar effect.
(Msg. 6) Posted: Fri Jul 25, 2008 6:55 pm
Post subject: Re: displaying records in a report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Looking through this forum, I was able to find my answer. Instead of a
group by in my query, i changed it to an expression thus allowing me to see
all of my data. Thanks again for the help and the link to the database.
den1jxt wrote:
>I got it all to work and it is great! I am running into an issue of greater
>than 255 charaters. Is there a way to specify the charater count? Sort of
>like a memo field.
>
>>Presuming you have a table with the ID and text, join it to
>>the report's record source query (on the ID fields) and use
>[quoted text clipped - 4 lines]
>>>>OTOH, if the commas are not critical, you could use a multi
>>>>column subreport to get a similar effect.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other