Access field joining

  Kypros 16:24 13 Dec 2003

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 2003

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.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)