address string

Jeanette · Jun 30, 2006

I want to insert a comma after [City] in the address string in my query.
Expr1: [City] & " " & [State] & " " & [ZipCode]. HELP!

Lucas Kartawidjaja · Jun 30, 2006

I believe you can do:
Expr1: [City] & ", " & [State] & " " & [ZipCode].

Lucas

Jerry Whittle · Jun 30, 2006

Expr1: [City] & ", " & [State] & " " & [ZipCode].

jahoobob via AccessMonster.com · Jun 30, 2006

Expr1:[City] & ", " & ...

I want to insert a comma after [City] in the address string in my query.
Expr1: [City] & " " & [State] & " " & [ZipCode]. HELP!