Access field joining

  Kypros 16:24 13 Dec 03
Locked

Attention all ace programmers!

I have an Access table of contacts containing several fields including phone code and phone number.
I also have just started to create an Outlook list of contacts.
I would like to join the Access phone fields together to create a new field containing code-space-number so that I can export it to Outlook as a single field for Home Phone.
Has anyone any idea how I can join the Access fields in this way without cutting and pasting dozens of numbers one at a time?

  keith-236785 18:01 13 Dec 03

in a query by example grid, where it shows the new field (you will need a new field for the merged data) change the text to

PhoneCode & " "Phonenumber

(obviously change these to whatever your fields are called)

dont know how you would incorporate it into your form as i cant see your form. then you could run a report and grab the full numbers from there (copy and paste) [i hope].

if you get stuck, send me an e-mail so i can send back an attachment.

good luck

This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017