Making a field by combining other fields

[Jobeibi]

I have a table that contains a UserID field and a JobID
field. The enduser of this table would like to have
another column that combines these two fields. I know how
to break a column up into two columns, but I don't know
how to glue them back together.

Can anyone help?

Thanks

 

[Joan Wild]

Your best bet is to create a query that gives them this.

UserID & " " & JobID

 

[Guest]

Thank you! That worked beautifully.