Merge two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I merge two pairs of fields into 1 pair of fields 4
Access Page Header with merge field 0
Merging date fields with "if" condition 1
Merge two columns 4
Help with Access Query! - Merging Rows with Unique ID 0
Referencing the product of merge fields between tables 0
Merging two tables with identical fields 3
Count text values in a Access Field 0

Back
Top