Combining 3 fields into one

[Guest]

I am an Access novice. I have 3 columns/fields in a query titled "Area",
"F1" and "F2" (They are the area code, then the first 3 digits of a phone
number and the last 4 digits of a phone number).

I need to combine the text in all three columns/fields into a new column
field to make it one complete phone number.

Any detailed help will be appreciated.

Thanks.

 

[Rick B]

I would add a new column to the query with the following in it....

FullPhone: "(" & [Area] & ") " & [F1] & "-" & [F2]

 

[Guest]

Phone:[Area]&[F1]&[F2]

 

[fredg]

I am an Access novice. I have 3 columns/fields in a query titled "Area",
"F1" and "F2" (They are the area code, then the first 3 digits of a phone
number and the last 4 digits of a phone number).

I need to combine the text in all three columns/fields into a new column
field to make it one complete phone number.

Any detailed help will be appreciated.

Thanks.

With or without () and hyphen?

Unformated:
FullNumber:[Area] & [F1] & [F2]
1234567890

Formated:
FullNumber:"(" & [Area] & ") " & [F1] & "-" & [F2]
(123) 456-7890

Why 3 fields? I can understand 2 fields [Area Code] and [Phone
Number], but breaking the Phone Number itself into 2 fields seems like
overkill.

 

[Guest]

Thank you all for the help.

Like I mentioned, I'm a novice. Can anybody walk me through the process
step by step. Once I have a query, where and when do I put in the statement
below. Also, why type of query am I running?

Thanks again!

I would add a new column to the query with the following in it....

FullPhone: "(" & [Area] & ") " & [F1] & "-" & [F2]



--
Rick B

I am an Access novice. I have 3 columns/fields in a query titled "Area",
"F1" and "F2" (They are the area code, then the first 3 digits of a phone
number and the last 4 digits of a phone number).

I need to combine the text in all three columns/fields into a new column
field to make it one complete phone number.

Any detailed help will be appreciated.

Thanks.

 

[Rick B]

In a NEW column in the query, in the box labeled "Field:" simply type
exactly what I posted...

FullPhone: "(" & [Area] & ") " & [F1] & "-" & [F2]


--
Rick B

Thank you all for the help.

Like I mentioned, I'm a novice. Can anybody walk me through the process
step by step. Once I have a query, where and when do I put in the
statement
below. Also, why type of query am I running?

Thanks again!

I would add a new column to the query with the following in it....

FullPhone: "(" & [Area] & ") " & [F1] & "-" & [F2]



--
Rick B

I am an Access novice. I have 3 columns/fields in a query titled
"Area",
"F1" and "F2" (They are the area code, then the first 3 digits of a
phone
number and the last 4 digits of a phone number).

I need to combine the text in all three columns/fields into a new
column
field to make it one complete phone number.

Any detailed help will be appreciated.

Thanks.

 

[Guest]

That did it! Thanks very much for all you help. Much appreciated.

In a NEW column in the query, in the box labeled "Field:" simply type
exactly what I posted...

FullPhone: "(" & [Area] & ") " & [F1] & "-" & [F2]


--
Rick B

Thank you all for the help.

Like I mentioned, I'm a novice. Can anybody walk me through the process
step by step. Once I have a query, where and when do I put in the
statement
below. Also, why type of query am I running?

Thanks again!

I would add a new column to the query with the following in it....

FullPhone: "(" & [Area] & ") " & [F1] & "-" & [F2]



--
Rick B



I am an Access novice. I have 3 columns/fields in a query titled
"Area",
"F1" and "F2" (They are the area code, then the first 3 digits of a
phone
number and the last 4 digits of a phone number).

I need to combine the text in all three columns/fields into a new
column
field to make it one complete phone number.

Any detailed help will be appreciated.

Thanks.