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
--Kathy