looking up data from 2 tables

  • Thread starter Thread starter Oscar Morejon
  • Start date Start date
O

Oscar Morejon

i have 2 tables 1 has the codes of the classes per period
and per student the other table has who that code
(teacher name) it belongs to What i need to do is do
lookup the code and export out the to another table
 
i have 2 tables 1 has the codes of the classes per period
and per student the other table has who that code
(teacher name) it belongs to What i need to do is do
lookup the code and export out the to another table
Click to expand...

Create a Query joining the two tables by class code.

It would rarely be necessary to "export out... to another table"; this
Query can be used directly as the recordsource of a Form or Report,
exported to text, or whatever.
 
Back
Top