joining fields

[Phil_L]

is there a way to join 2 fields?

for example

Field 1
a
b
c

Field 2

d
e
f

Joined field

a
b
c
d
e
f

cheers

Phil

 

[Pat Hartman]

You ask how to join two fields but that's not what your example shows. Your example seems to concatenate two lists. You would use a union query to concatenate two queries or tables into a single recordset.

Select fld1, fld2, fld3 From tblA
Union Select fld1, fld2, fld3 From tblB;