3 queries to split a big table into excel file

[accessfever]

I have a big table and I use 3 queries to split it into 3 excel files. However, it looks like the 3rd query does return less records:

1st query: "ProductKey1" field = like "E"
1st query: "ProductKey2" field = is null

2nd query: "ProductKey1" field = like "F
2nd query: "ProductKey2" field = is null

3rd query: create new "CHECK" field ([ProductKey1]&[ProductKey2]) = (not like "E" and not like "F") Or is null

Any idea why the 3rd query is not working?

 

[Guus2005]

please elaborate.
1st query where ProductKey1 like "E" is the same as where ProductKey1 = "E" why use like?

what do you mean by
3rd query: create new "CHECK" field ([ProductKey1]&[ProductKey2]) = (not like "E" and not like "F") Or is null

?

 

[accessfever]

i think i figured out what went wrong. Thanks for your email.