473,507 Members | 2,395 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Microsoft Access Combining fields

10 New Member
So I have a table in Microsoft Access with mostly employees information.Employees' name are separated into two fields..last name and first name. I was wondering if there's a way to have a field in the same table that combined both First Name and Last Name together(like in excel). I know that you can do it in a query but it's just would be a repeat of the same table with the combined First and Last Name only.

Thanks for your help.
Apr 12 '12 #1
0 1176

Sign in to post your reply or Sign up for a free account.

Similar topics

3
13005
by: Victoria Holowchak | last post by:
I was hoping that Microsoft Access 2002 would allow users to see all the columns of an Oracle database table that contained more than 255 columns. I noticed that my Oracle8 ODBC driver is only at...
1
5375
by: Miguelito Bain | last post by:
hi everybody. i'm trying to find out what you can and can't do with/in calculated fields. any help, pointers, and/or advice would be greatly appreciated. i'm a newbie, but i want to learn, and...
5
5400
by: Alan | last post by:
Hello, I trying to export my email to an access database. Outlook already this function, but not all the fields are available once the export is complet. The time & date stamps are not...
2
1253
by: Randy | last post by:
I am trying to make the move from Approach to Microsoft Access and am having real problems with developing forms? Would someone please describe the Access concept of developing forms using...
1
8426
by: Ratnest | last post by:
Hi, I'm new to Microsoft Access today, so this is probably a very basic question for all you clever people out there. Anyone know how I copy down a column in Microsoft Access? It doesn't seem...
2
3076
by: bobc | last post by:
Any help appreciated with this problem -- I have a Microsoft Access 2002 application. The Access mdb has a refence to DAO 3.6 (not ADO). A form is bound to a linked table in a second mdb. In the...
3
1983
by: jeffhg582003 | last post by:
Hi, I am developing a python script which add records to a microsoft access tables. All my tables have autogenerated number fields. I am trying to capture the number generated from the insert...
5
6073
by: trig | last post by:
Please help! I am an ICT teacher at a secondary school and my year 12 (AS Level) group need to create a website where data can be sent from a form to a Microsoft Access database. I am trying...
9
13321
by: kzzz | last post by:
Hello, I have a microsoft access file with fields that have "long binary data". I would like keep the same file, but change the "long binary data" into regular text. There are a large number of...
9
6281
by: Leelee | last post by:
I have a Start Date field and a End date field in one of my tables. I have a report that I created and I want to combine the two fields into one so that it reads as follows: 01/01/2010 to...
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7319
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7485
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5042
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
760
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.