Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combine 3 text fields into one field 1

Status
Not open for further replies.

KathyRingwood

Technical User
Nov 26, 2007
12
Hi: I am using a query datasheet as a simple report. I want to take text data from three fields and combine them into one field (i.e. firstname, middleinitial, lastname). Is it possible to do this in a query? I have tried creating a report where I can do this easily, but my datasheet has 59 fields and needs to be in a datasheet or spreadsheet format. I am obviously missing something but it's been awhile since I've worked in Access! Thanks for any help you can provide.
--Kathy

 
Duane,

Thanks very much. It worked! (I'm always so surprised when something works--I don't know why). I can now move on to my next tasks. Thanks for helping. I for one (and I know I speak for many) really appreciate it.

--Kathy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top