Count with expression

[labbadabba]

Hello all,

I'm trying to perform a count function that tells me how many accounts are over $25,000 and have more than $10,000 commission. The expression I tried is below but it gave me the total number of accounts.

I need this report by tonight, any help would be very welcome.

Thanks,
Ty


=Count([QRY_Japan_0306]![MARKET VALUE]>25000 And [QRY_Japan_0306]![YTD2006 REVENUE]>10000)

 

[Smart]

Try this


SELECT Count(IIf([QRY_Japan_0306]![MARKET VALUE]>25000 And [QRY_Japan_0306]![YTD2006 REVENUE]>10000,0)) AS Total
FROM YourTable;

It should work