Query Criteria for a Newbie

N

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
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Taking the sum between two dates 2
Where did my criteria table go in query design? 1
Insert a default record for all values 3
Query between dates 1
concatenate text field problems 4
Union query or Outer Joins do not create desired results 3
Query Criteria 2

Top