Hello Everyone,
I have a very elementary problem that I just can't seem to get
passed. I am writing a very simple select query, but it is not
running properly.
SELECT qryUnionAging.Invoice_Number,
qryUnionAging.Invoice_Current_Balance,
qryUnionBindInvoiceAndInventory.owner_id
FROM qryUnionBindInvoiceAndInventory RIGHT JOIN qryUnionAging ON
qryUnionBindInvoiceAndInventory.Invoice = qryUnionAging.Invoice_Number
WHERE (((qryUnionBindInvoiceAndInventory.owner_id)<>"RMP"));
For some reason, when I run this query it is exluding the RMP records,
but also excluding any records where the field is blank (Null). I'm
stumped! Any ideas whould be appreciated.
Dawn
