MS Access

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

Guest

how do i merge the values in two fields in two different tables into a third
filed that displays the values of both felds in a query or form.


Table1.firstname Table2.firstname
query.firstname
cathy sammy
cathy
john nancy
john
andy david
andy

sammy

nancy

david
 
aj20 said:
how do i merge the values in two fields in two different tables into
a third filed that displays the values of both felds in a query or
form.


Table1.firstname Table2.firstname
query.firstname
cathy sammy
cathy
john nancy
john
andy david
andy

sammy

nancy

david
Click to expand...

More information needed. How are these two tables related and why are
there two tables?
 
Assuming you're using the QBE grid:

Create a new field on the grid as Combined: [Table1.firstname] & " : " &
[Table2.firstname]

On your report refer your textbox to field Combined.

HTH
 
Larry Daugherty said:
Assuming you're using the QBE grid:

Create a new field on the grid as Combined: [Table1.firstname] & " : " &
[Table2.firstname]

On your report refer your textbox to field Combined.

HTH
--
-Larry-
--

aj20 said:
how do i merge the values in two fields in two different tables into a third
filed that displays the values of both felds in a query or form.


Table1.firstname Table2.firstname
query.firstname
cathy sammy
cathy
john nancy
john
andy david
andy

sammy

nancy

david
Click to expand...
Click to expand...


Thanks, the combined field helped
 
Back
Top