MS Access

[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

 

[Joseph Meehan]

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

More information needed. How are these two tables related and why are
there two tables?

 

[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

 

[Guest]

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

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

Thanks, the combined field helped