displaying records in a report

[den1jxt via AccessMonster.com]

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

Thanks to all

 

[Marshall Barton]

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

You can use a function to build the comma separated list.
There's a good one at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

OTOH, if the commas are not critical, you could use a multi
column subreport to get a similar effect.

 

[den1jxt via AccessMonster.com]

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

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/...Generic Function To Concatenate Child Records'

OTOH, if the commas are not critical, you could use a multi
column subreport to get a similar effect.

 

[Marshall Barton]

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]

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

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/...Generic Function To Concatenate Child Records'

OTOH, if the commas are not critical, you could use a multi
column subreport to get a similar effect.

 

[den1jxt via AccessMonster.com]

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
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]

 

[den1jxt via AccessMonster.com]

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.

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]