combine fields

[learning]

I have a database with one field called area and one field called number. both are text fields. I would like to add contents of area to number in front of number and then delete area field. like so....

area --- number ----- number

904 --- 555-1212 --- 904-555-1212

Is there an easy way to do this?

Thanks in advance.

Larry

[-Queue-]

Navigate to a layout containing the number field and put your cursor in the field. Then go to Records->Replace, select 'Replace with calculated result', and specify the calc as area & "-" & number.

[learning]

Queue

Thanks so much--------------it worked great.

Larry