merging two fields in a table

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

Guest

I have two fields (group and subgroup) in one table (travel)........they are
both numeric. I would like to create a new field in the table that combines
the group and subgroup...how can I do than please?
 
You don't. If you have both values in the table, then to store them again
(combined) in a new field would be redundant. What happens if you change
one of the values?

Instead, simply combine them in your queries, reports, and forms.

=group & subgroup


Hope that helps,

Rick B
 
Back
Top