Creating Query between 2 tables

[Carla]

What steps do i take to create a query to pull data from
2 different tables? For example: TableA: has $$ data
and TableB: has grading scale (need to find if student
has A or B grade). How can i pull both pieces of data
from 2 separate tables to answer my query?

Any help would be appreciated,
thank U

 

[mcowie]

Carla,

You need to include both tables in your query, and create a
relationship between those tables on a common field (it sounds like
both the tables you need should have a 'GRADE' field or similar).

HTH


=================================================================