Applying criteria to a expression.

[TDC21]

It seems like I must be missing something very simple, I created a simple Query from a table with Inventory QTY transactions, they are grouped by IN and OUT transaction types. I used expression builder to to create a simple custom column [IN] - [OUT]

The column is working just fine but when I add >0 into the Criteria the Query dose not return any values at all.

Anyone know what I am missing?

 

[Joe4]

Works just fine for me.
Are IN and OUT numeric columns?
Are they populated for every cell, or are their NULLS in there?
Can you switch your query to SQL View, and copy and paste your SQL code here so we can see what you have?

 

[TDC21]

Yeah, I needed to quadruple check my other filters, I figured I was missing something but I just wasn't seeing it at first.

Sorry for wasting anyone's time