greater than question

[jasn_78]

hey guys i have the following query but the greater than part isn't working it is still showing all records

SELECT AREATBL.AREA_DESC AS AREA, 
            IDEPTBL.IDEP_DESC AS DEPARTMENT, 
            ITEMTBL.ITEM_DESC AS ITEM, 
            ITMATBL.ITMA_PRICE_1 AS RRP, 
            IIf([ITMATBL]![ITMA_PRICE_1]<>0,(([ITMATBL]![ITMA_PRICE_1]-([SCSTTBL]![SCST_LAST_INV_FINAL_COST]/[ITEMTBL]![ITEM_CTN_QTY]))/[ITMATBL]![ITMA_PRICE_1])*100) AS GP,ITEMTBL.ITEM_NUMBER
FROM 
   ((ITMATBL INNER JOIN (ITEMTBL 
     INNER JOIN IDEPTBL ON ITEMTBL.ITEM_IDEP = IDEPTBL.IDEP_NUMBER) 
     ON ITMATBL.ITMA_ITEM_NUMBER = ITEMTBL.ITEM_NUMBER) 
     INNER JOIN AREATBL ON ITMATBL.ITMA_AREA_NUMBER = AREATBL.AREA_NUMBER) 
     INNER JOIN SCSTTBL ON (ITEMTBL.ITEM_NUMBER = SCSTTBL.SCST_ITEM_NUMBER) 
     AND (AREATBL.AREA_SYSC_NUMBER = SCSTTBL.SCST_SYSC_NUMBER)
WHERE 
     (((AREATBL.AREA_NUMBER)=[Forms]![FRMGP]![Combo16]) 
     AND ((ITMATBL.ITMA_PRICE_1) Is Not Null 
     And (ITMATBL.ITMA_PRICE_1)>0) 
     AND ((ITMATBL.ITMA_ACTIVE_YN)="Yes") 
     AND ((ITMATBL.ITMA_SEND_TO_TILL_YN)="Yes") 
     AND ((IIf([ITMATBL]![ITMA_PRICE_1]<>0,
         (([ITMATBL]![ITMA_PRICE_1]-([SCSTTBL]![SCST_LAST_INV_FINAL_COST]/           [ITEMTBL]![ITEM_CTN_QTY]))/[ITMATBL]![ITMA_PRICE_1])*100))
	   >[Forms]![FRMGP]![txtTARGETGP]))
GROUP BY 
     AREATBL.AREA_DESC, 
     IDEPTBL.IDEP_DESC, 
     ITEMTBL.ITEM_DESC, 
     ITMATBL.ITMA_PRICE_1, 
     IIf([ITMATBL]![ITMA_PRICE_1]<>0,
     (([ITMATBL]![ITMA_PRICE_1]-([SCSTTBL]![SCST_LAST_INV_FINAL_COST]/       [ITEMTBL]![ITEM_CTN_QTY]))/[ITMATBL]![ITMA_PRICE_1])*100),        ITEMTBL.ITEM_NUMBER;

thanks

 

[jasn_78]

hey guys nevermind figured it out have to use CInt on the command