Unmatched query

[jkdaman]

Hello!!!

I am having a little trouble with unmatched query. I am trying to accomplish a number in the final report which is in the list A but not in list b. As showen in the list below.

List A List b final
1 1
2 2
3 3
4 4

I am just wondering if some body could help me with the unmatched code. There is no help under Access 2000 helpdesk.

 

[dodgychris]

You could try this:

SELECT ListA from ListA
where ListA not in (select ListB from ListB)

I've kind of assumed that ListA and ListB are different tables, let me know if their columns though, and I'll see what I can do.

Hope this helps, Dodgy Chris
-----------------------------------

confucious say : better to save a mans life than to build 7 storey pagoda