Access field joining

  [DELETED] 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?

  [DELETED] 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

Microsoft Surface Book 2 15in review

Illustrator Amy Grimes on how setting up her own eco-brand led to success with clients too

MacBook Pro keyboard issues and other problems

Test : l’enceinte connectée HomePod d’Apple