Different field names, same data

  • Thread starter Thread starter charlesr
  • Start date Start date
C

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
 
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?
Click to expand...

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