Query works; but why?

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

In the query design window I have two tables:

"SumofSuppCost"
"SuppCost.

The aim is to supply the last cost paid for
an item irrespective of supplier.

I find that if I have two connections between
the above tables in the design grid, then it
works. The connections are between the
fields 'ProductID' and 'EntryDate'

Do the two connections mean a "double filter"
of some sort?

Please help, Frank
 
The two connections mean that you are joining two fields from each
table together. When you set a join like that you are asking for
records where the joined fields are equal. So in a way you could say
that you are filtering on those two fields.

Hope that helps!
 
Thanks.

It's just that I have never seen this done in
all the many examples in the text books. I
thought there may be some problem with the
method.

Or there may be a better way to do the same
thing.


message
 
Back
Top