Two criteria sets work seperate, fail together

P

Phil

I have a query on three linked tables. Selecting a basic set of
criteria, as follows, returns 13 records.

WHERE (((item.item_id)<>0) AND ((item_warehouse_link.average_cost)<=0)
AND ((item_warehouse_link.onhand_qty)<>0) AND ((item.company_id)=1) AND
((item_warehouse_link.company_id)=1))

Changing the criteria to something utterly simple, (note I am applying
it against item.item_id, part of the first criteria set)

WHERE (((item.item_id)=21041))

returns 53 records, none of which are covered by the 13 record return.

Therefore, if I combine the two, I should get 53 + 13 records returned.
Instead, when I combine them, like so,

WHERE (((item.item_id)<>0) AND ((item_warehouse_link.average_cost)<=0)
AND ((item_warehouse_link.onhand_qty)<>0) AND ((item.company_id)=1) AND
((item_warehouse_link.company_id)=1)) OR (((item.item_id)=21041))

I get an error:
"The Decimal field's precision is too small to accept the numeric you
attempted to add"

Access 2002 sp3
 
Top