Query Criteria for a Newbie

[Nurse Nancy]

I have a Query with many tables. So far I have gotten the results I need just
by using the Outer Joins.

Now the last step is to compare 2 tables with similar fields.

Product Table and Station Table

I only want to return records from the Station Table if the Station Rank is
less than or equal to the Product Rank

So What do I put in the Criteria field for each of these fields?

Hope you can help me
Nancy

 

[KARL DEWEY]

In design view --
Field: Product Rank
Table: Product
Criteria: <=[Station Rank]