Originally Posted by
Cottonshirt
I think you will find that this problem occurs where you have a join on a field that may contain nulls.
because Null does not have a value ACCESS cannot compare nulls, it cannot even determine whether one Null equals another Null. therefore, when your join field contains Nulls at either end ACCESS cannot determine whether these fields comply with whatever your join criteria are, and skips them.
one solution would be to run a query that extracts from tbl_main only those records where [disposition] is not Null, and then use that query as the recordsource for your main query.
good luck with your project,
Cottonshirt
I created a query NOT NULL DISPOSITIONS and used that to join to the dispositions table but I still do not get the value of Demo returned in the results.
Here is the new query
Code:
SELECT [NOT NULL DISPOSITIONS].REP_NAME, [NOT NULL DISPOSITIONS].Disposition, Count([NOT NULL DISPOSITIONS].EXP_Q) AS CountOfEXP_QFROM tbl_dispo LEFT JOIN [NOT NULL DISPOSITIONS] ON tbl_dispo.Disposition = [NOT NULL DISPOSITIONS].Disposition
WHERE ((([NOT NULL DISPOSITIONS].PRICE_PLAN_GROUP)="TERM LEASE") AND (([NOT NULL DISPOSITIONS].EXP_Q)="2"))
GROUP BY [NOT NULL DISPOSITIONS].REP_NAME, [NOT NULL DISPOSITIONS].Disposition;