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)

 

[uncle-lai]

See if this can do:

Create an invisble text box [txtCount]
set it's Control Source = IIf([MARKET VALUE] Between 9999 And 24999, 1, 0)
set it's Running Sum to Over All
In the Group Footer set your required text box = [txtCount]