Unmatch Query Help

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

I have 2 queries and I am trying to get a list of unmatched MSEQ from the
qryYrMoSeq.

qryYrMoSeq is a listing of available seq#. In qryBoilerSerialNum is the a
list of seq# that are taken.

So what I am trying to do is see what seq# are still available. When I run
the query it comes up blank.

SELECT qryYrMoSeq.YearBlt, qryYrMoSeq.M_SEQ, qryYrMoSeq.MSEQ
FROM qryYrMoSeq LEFT JOIN qryBolierSerialNum ON qryYrMoSeq.MSEQ =
qryBolierSerialNum.MSEQ
WHERE (((qryBolierSerialNum.MSEQ) Is Null));

Any ideas what I am doing wrong?
 
Is it not possible that all qryBolierSerialNum.MSEQ are found into
qryYrMoSeq.MSEQ ?


Vanderghast, Access MVP
 
I guess what I am trying to do is see which MSEQ numbers are not used from
the qryYrMoSeq.

Matt

Michel said:
Is it not possible that all qryBolierSerialNum.MSEQ are found into
qryYrMoSeq.MSEQ ?

Vanderghast, Access MVP
I have 2 queries and I am trying to get a list of unmatched MSEQ from the
qryYrMoSeq.
Click to expand...
[quoted text clipped - 12 lines]
Any ideas what I am doing wrong?
Click to expand...
Click to expand...
 
Back
Top