Access 2002 - DLookup and punctuation

[cantes903]

I think this is a simple problem but I can't figure it out.
I have a DLookup that I want to format:

City, State ZipCode (it needs to have the comma and spaces.
Here's what I have now:

=DLookUp("[City]&[State]&[ZipCode]","tblCompanyInfo","ID=1&quot

How do I get the comma and spaces?

Thanks in advance,
Christy

 

[grobermatic]

Try this:

=DLookUp("[City]","tblCompanyInfo","ID=1&quot & ", " & DLookUp("[State]","tblCompanyInfo","ID=1&quot & " " & DLookUp("[ZipCode]","tblCompanyInfo","ID=1&quot

Craig

 

[JohnLowell]

You could also try:

=DLookUp("[City]& ', ' & [State]& ' ' & [ZipCode]","tblCompanyInfo","ID=1&quot

 

[cantes903]

Thanks ya'll! It works good now.

Christy