concatenate different fields to run together with a comma

B

Beaugie

I am designing a report and I want the address section to run together with
comma and spaces where appropriate, such as:
Mississauga, FL 56569
Racine, WI 53555
Milwaukee, WI 55565

I do not want big gaps or spaces between fields
 
F

fredg

I am designing a report and I want the address section to run together with
comma and spaces where appropriate, such as:
Mississauga, FL 56569
Racine, WI 53555
Milwaukee, WI 55565

I do not want big gaps or spaces between fields
Click to expand...

Use an unbound control.

=[City] & ", " & [State] & " " & [Zip]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Null fields in a calculated field 3
Concatenate fields, but not if null 4
Concatenate 3 fields on the reports 3
Concatenate and commas 4
Keep data from a field together as typed 4
Displaying Check Boxes in Report 1
Concatenation subreports in report - formatting question 0
Shading Header / Footers and separating all rows with lines; weird whitespace 0

Top