Different field names, same data

[charlesr]

I have two tables: one, created from a monthly report that
is sent to us by the laboratory and uses the
field "medrecno."

My other table is the one we continually use and contains
the field "patient id"

I want to make a query using the two tables but I need it
to recognize the medrecno and patientid are same. Is
there a way to do this without renaming one of the two
fields?

Many thanks.

Charles

 

[John Vinson]

I want to make a query using the two tables but I need it
to recognize the medrecno and patientid are same. Is
there a way to do this without renaming one of the two
fields?

A UNION query will "string together" the two tables; the names need
not match but the datatypes must. See UNION in the online help.