Area code

[ChrisDo11]

i have a table with contacts. the table has an "area code" filed. I'd like to have the area code show up in brackets ie. (456)768-9088 on my report. is there a way of doing this? the only way i have found so far is to physically put brackets on the report around the "area code" field. i would prefere that the brackets only show up if an area code is entered....

thanks...

i am also interested in showing a "," after a city name and before the province/state. the city name and province/state are separate fields in my table as well. i can't physically put a comma on the report as some city names are longer than others....

thanks again....

 

[Mile-O]

1) Format([Field],"(000) 000-0000"

2) Concatenate the fields in the query that underlies the report:

i.e.

Location: [City] & ", " & [State]

 

[ChrisDo11]

thank you,

#2 worked fine, but i can't seem to get #1....

i have a field in my table for the area code only so i've been using the following in the "format" of the text box on the report.

([faxareacode],"(000)"

am i still missing something?