Hi I think this may be an easy question for some of you that know SQL. I have the following expression in a query which strings togetehr on address format from different fields. As you can see I have a comma seperating the City and the St (State) like you see in typical address format. What i would like to do is possibly have a space in between the Generator site address and the City for example...
1234 Access Road
Baltimore, MD 23456
What can i put in place of the comma to make the address show up in this format, (ie. can i put a word like "Enter" in the spot and it will automatically put the city, state, and zip on the next line? Thanks
Expr1: Trim([Generator’s Site Address]) & " " & Trim([City]) & ", " & Trim([St]) & " " & Trim([Zip Code])
1234 Access Road
Baltimore, MD 23456
What can i put in place of the comma to make the address show up in this format, (ie. can i put a word like "Enter" in the spot and it will automatically put the city, state, and zip on the next line? Thanks
Expr1: Trim([Generator’s Site Address]) & " " & Trim([City]) & ", " & Trim([St]) & " " & Trim([Zip Code])
