Complex Query

[John Hebert via AccessMonster.com]

OK, I've browed through the threads and can't find a clue that can help me.
This is what I have -
Database with multiplte tables:

- Master Table (my term) is 3QYTD with many fields, key is UI

- 19 Data tables with only three fields, updated by field personnel, key is
also UI (data originally drawn from
master table, and modified by field personnel

I joined them using an outer join in the query design tool, which shows me
what I want, essentially all of the records from the master table, and any
reuqested changes from the field people, an example is shown below:

UI Master Table FP#2 FP#3
FP#5
WE47332 -200 -200 -200
208017440
WE47333 -200 -200 -200
208017440
WE47334 -200 -200 -200
208017440
WE08 208042900 208042900 208042900

WE09 208019415 208019415 208019415 208019415
WE10 208044329 208044329
208017614
WE11 208015245 208015245 208015245 208015245
WE12 208015245 208015245 208015245 208015245
WE13 208019415 208019415 208019415 208017614

What I want to do is to show the UI ONLY when the data from the field
personnel (FP above) does not match the data in the master table. So the
query should return the following based upon the above data set:

WE08
WE09
WE11
WE12

Any ideas as to how this can be done easily, keeping in mind that I've got 19
tables joined in the query. It might be easiest to do in a report, but my
thinking is that I need to distill this down in a query. I appreciate any
help someone can give . . .

Regards,
John

 

[John Vinson]

What I want to do is to show the UI ONLY when the data from the field
personnel (FP above) does not match the data in the master table. So the
query should return the following based upon the above data set:

Simply put a criterion on each FP table's value

<> [MainTable].[fieldname]

using OR logic by putting each criterion on a separate grid line in
the query.


John W. Vinson[MVP]