combining fields

[Gash13]

I have a large table that I imported into an Access (97) database.

Everything is working great, However I need to combine two of the table's fields into one field. (Or I'll have to re-enter all the information by hand.) For example: Field 1 is "LastName", Field 2 is "FirstName". I need to combine the fields into a field called "Name".

I know it would probably be best to keep the fields seperate, but for my purpose I need them together. Plus it would be a MAJOR overhaul to go through all the forms and reports and etc.to seperate them.

Any ideas...

 

[LonnieJohnson]

1. Add the new field FullName to your table.
2. Create an update query using your table.
3. Add your new field (FullName).
4. In the Update To section of the query put..
[FirstName] & " " & [LastName]
this will give you "John Doe". Or you could put...
[LastName] & ", " & [FirstName]
this will give you "Doe, John"

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Gash13]

Thanks. That was simple enough...