Report with Street (header) and address number as details...

[klepto84]

Hi. I am new here so if I breach protocol, please be gentle!!!
I have a 1200 page report which is a list of addresses in this form--10 Bob St
12 Bob St
14 Bob St

I could reduce the paper waste and make the report more user friendly with this--Bob St
10, 12, 14

I've grouped by street and get the header fine, but how can I get the address numbers to display horizontally? I can easily add a comma and space to each address number by concatenating ", ".

Thanks

[June7]

Requires VBA code. Review http://allenbrowne.com/func-concat.html

However, separating the building number from street name so the street name is not replicated in the string could be difficult.

[orange]

What is this 1200 page report for?
Who will use it?
What is the source of your data?
Can you post 20-30 records?


What is the business issue/opportunity for which a 1200 page report is the answer?

[klepto84]

Requires VBA code. Review http://allenbrowne.com/func-concat.html

However, separating the building number from street name so the street name is not replicated in the string could be difficult.

The building number and street names are separate fields and do not require separation. That is easily done in Excel using text to columns.

Thanks for your response.

[klepto84]

What is this 1200 page report for?
Who will use it?
What is the source of your data?
Can you post 20-30 records?


What is the business issue/opportunity for which a 1200 page report is the answer?

With all due respect, those questions are not germane to the discussion and I am not comfortable sharing that information online. If I was asking database design questions, absolutely these issues are important. I want to make what I thought would be a minor report display change to an existing multi-user database.

I am getting this:

1 Bob St
2 Bob St
3 Bob St
4 Bob St
etc.
Street and number are separate fields

and I want

Bob St
1 ,2, 3, 4, 5, 6, 7, 8, 9, 10 etc.

Because 90% of my sheets are blank space.

Seems programming that is beyond my Access skill level is required.

Thanks for your time.