Complicated comparing of a table to its self

[cakin]

I'm trying to make 84 queries then run them with a module, this is the easy part.

The hard part is making the query, i need each query to compare a key set of events to a sub set of its self.

So i need say key set 01-01 (column a) which has 400 events in column B to compare it to its sub set (all which will be 01-01.###### there will always be the decimal after the key part and also in column a) to make sure that none of the sub sets have any events in column B besides the ones in the key. i would like to simply flag all the ones that aren't in the key in column D.

The biggest issue is this table changes every week (over 2 million entries) so i'd like to do something i can repeat every week quickly, like maybe just copy the table and use it to compare to the original.

A	B	C	D
01-01	5656	-
01-01	5657	-
01-01	5658	-
01-01	5659	-
01-01.33	5656	-
01-01.33	5657	-
01-01.33	9999	-	error
01-01.33	7777	-	error
01-01.34	5659	-
01-01.34	0000	-	error
01-01.35	5656	-
01-01.35	8888	-	error

[June7]

Will all data have 01-01 prefix - no 02-02 or 01-02?

Try:
SELECT Left([A],InStr([A],".")-1) AS Prefix, A, B FROM Table3
WHERE A Like "##-##.*" AND B Not In(SELECT B FROM Table3 WHERE A Like "##-##");

[cakin]

Will all data have 01-01 prefix - no 02-02 or 01-02?

Try:
SELECT Left([A],InStr([A],".")-1) AS Prefix, A, B FROM Table3
WHERE A Like "##-##.*" AND B Not In(SELECT B FROM Table3 WHERE A Like "##-##");

It will have 01-02, 02-01, 02-02, ect but they should be completely separate compares since they will have different event for sure and thats okay, just not if 02-02 was compared to 02-02.### and had a different event from 02-02.

[June7]

Need representative dataset to test. Provide file - Excel or Access. Follow instructions at bottom of my post.