I want to insert a comma after [City] in the address string in my query.
Expr1: [City] & " " & [State] & " " & [ZipCode]. HELP!
Lucas Kartawidjaja - 30 Jun 2006 19:53 GMT
I believe you can do:
Expr1: [City] & ", " & [State] & " " & [ZipCode].
Lucas
> I want to insert a comma after [City] in the address string in my query.
> Expr1: [City] & " " & [State] & " " & [ZipCode]. HELP!
Jerry Whittle - 30 Jun 2006 19:53 GMT
Expr1: [City] & ", " & [State] & " " & [ZipCode].

Signature
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I want to insert a comma after [City] in the address string in my query.
> Expr1: [City] & " " & [State] & " " & [ZipCode]. HELP!
jahoobob - 30 Jun 2006 20:27 GMT
Expr1:[City] & ", " & ...
>I want to insert a comma after [City] in the address string in my query.
>Expr1: [City] & " " & [State] & " " & [ZipCode]. HELP!