M
Marty
It's a little hard to follow what you're asking but I'll
give it a try. If you want to show only the records in
table 2's indexRate that do not match table 1's indexRate
you would:
In the lower half of the query (the selected fields
section) in the Criteria field under Table2.IndexRate you
would put <>[Table1]![IndexRate]. This will return a
query that shows all fields that match in both tables
policy numbers (assuming that's the field you linked) and
only the IndexRate records from Table2 that do not match
Table1. You may also want to try double clicking the line
that goes between the linked fields. This will give you
option dialog box to: 1. Show all fields that match in
both tables. 2. Show all the fields in Table1 and only
those that match from Table2. 3. Show all the fields from
Table2 and only those that match from Table1.
Hope this helps, Marty
give it a try. If you want to show only the records in
table 2's indexRate that do not match table 1's indexRate
you would:
In the lower half of the query (the selected fields
section) in the Criteria field under Table2.IndexRate you
would put <>[Table1]![IndexRate]. This will return a
query that shows all fields that match in both tables
policy numbers (assuming that's the field you linked) and
only the IndexRate records from Table2 that do not match
Table1. You may also want to try double clicking the line
that goes between the linked fields. This will give you
option dialog box to: 1. Show all fields that match in
both tables. 2. Show all the fields in Table1 and only
those that match from Table2. 3. Show all the fields from
Table2 and only those that match from Table1.
Hope this helps, Marty