Using the Find Unmatch Query (1 Viewer)

[durdle17]

Hey,

I am having some trouble using the a unmatched query. Bascially I have 3 tables(Master, Table1 and Table2). In the three tables I have a unqiue field(Not the Primary) named ID#. I want to run a query on Master table and return the ID# if it is not listed in either Table1 or Table2.
Any help would be great.

Thanks

 

[neileg]

Create a union query between 1&2. Then run an unmatched query between master and the union query.

 

[durdle]

Hi,

I have the union query created but when I go throught the "Find Unmatch query wizard" it do not let me add the union I created.

Any idea?

Chris
________
toyota tf109

 

[neileg]

Just in case I was going mad, I've just run thrugh the process with some dummy data. Works fine for me.

When you say the wizard won't let you add the union, do you mean you can't see it in the selection list, or that you can see it but it won't select, or what?

 

[FoFa]

Try:
Select ID from MyTable
Where ID NOT IN (Select ID from MyUnionQuery)

 

[durdle]

Neil,

Here is the message I get when I try to select the union query in the wizard
"There are no fields in this table or query that are valid for a join. Select a table or query that contains at least one field that does not have the Memo or OLE data type."

thanks
Chris
________
gaston chevrolet

 

[neileg]

Surely the ID# is neither OLE or memo, and that's the one you want to match on.

 

[durdle]

Hey neileg,

The ID is not a Memo or OLE. I have the query working now thanks.

Chris
________
buy vaporizer