Skip to Content
0
Former Member
Nov 04, 2009 at 10:29 AM

Record Selection Formula being ignored

122 Views

Hi all,

I'm creating a product report that should only display records where the product quantities (including any on order) is greater than 0. So basically the sum of 2 fields > 0.

My record selection formula looks like this (not exact field names but you get the idea):

(STOCK.QTY + STOCK.QTY_ON_ORDER) > 0

however when I view the SQL query it seems to be completely ignoring this formula

Am I doing something wrong?

Thanks

Gavin