MS Access

A

aj20

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
 
L

Larry Daugherty

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
 
A

aj20

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
 
Top