Merge two fields

F

FJinSA

Ok I need help, I have two fields in a table that I want to merge into one,
one is EMP_NUMBER and the other is EMP_GID and want to create a field
UNUMBER. I am having a hard time finding the right steps to do this....any
help is greatly appreciated.
 
R

Rick B

In a query, add the following as a new column...


UNUMBER: [EMP_NUMBER] & [EMP_GID]


This will create a new field called "UNUMBER" that will be displayed when
you run the query. This query can be used as a data source for your reports
and forms.

If you don't want to do it in your query, then just add a new unbound text
box to your forms and reports and type the following in it...

= [EMP_NUMBER] & [EMP_GID]
 
Top