record wrap text box-report

[Guest]

I have a boss who wants me to create a report he did by hand years ago. He
listed out store numbers separated by a comma. Like
this....3252,4525,325,856. Now the info is in an access 2003 database. My
problem is there is one store per record, and I can't figure out how to get
the report to wrap records like this. I could do without commas if I can get
it to wrap. Any suggestions?

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Guest]

Thanks Allen! Though this shows how to combine multiple fields in a one to
many relationship, my problem lies in that all my values are in the same
field. For instance, I have one location associated with many stores. My
report will group the stores by location, but only one store underneath the
other. I need them listed out to the right beside each other. Example:
Location Stores
320
852, 3258, 4258

I'm not that familiar with programing, and I can't figure out how and where
to use "concat" to do this. Thanks for the suggestion though!

 

[Allen Browne]

You have some kind of field in your table that indicates the Location?

If so, you can treat that field as the foreign key field, even if you don't
have a table of locations (which would be the best design.)

In that way, you can combine the store names from the different records that
match on Location.