Stumped on Reporting issue

[newegg]

I have a query with a field called "Address"

Address: (qryNames]![HouseNumber]) & (" "+[qryNames]![StreetNameT]) &
(" "+[qryNames]![StreetTypeT]) & (" "+[qryNames]![StreetSuffixT]) & ("
"+[qryNames]![AptNumber]) & (", "+[qryNames]![CityT]+",") & (" "+
[qryNames]![StateT]) & (" "+[qryNames]![Zip]))

When I runt he query, things format great, this would result in:

1000 Oak Street South #101, Mytown, MN 55555

But when I build a report and drop the address field in, things format
with extra spaces, like:
1000 Oak Street South #101 , Mytown , MN 55555

A few things I did and why:
1. Trimmed all the field that make up that big string, like
StreetNameT: trim(streetname)
2. Not all the fields I'm stringing together might not exist, that's
what I did use the normal concat method of field1 & " " & field2

Any ideas on how I can get my string to format correctly on a report?

 

[KARL DEWEY]

Try TRIM in the report.