field criteria only show negative value 1

[MICKI0220]

I have a report that one of the fields is negative carryover. However based on querying and nz feature this field also shows positive values. When the report runs, is there a way to make it only show the negative values, kind of like filtering on the field?

 

[PWise]

add to query

Select ..... table1.[negative carryover]-nz(table2.[negative carryover]-,0) 
from tablename
where table1.[negative carryover]-nz(table2.[negative carryover]-,0) <0