Access field joining

  Kypros 16:24 13 Dec 03

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…