I'm having trouble creating (what seems should be) a simple multi-table query. Basically, I have two fields on which I am doing a Count (e.g. No_Installed, and No_Removed); I have a third field which is an Expression (e.g. No_Delta) that is [No_Installed]-[No_Removed].
What I want to do is to limit the query to only show data where No_Delta < 0, but when I try to do that no rows appear at all.
In the meantime, I found a solution which seems to work quite satisfactorily: instead of trying to restrict the data based upon Delta<0 within the query, I added the following filter (outside the query):