Dcount issue! 3

[Monzer]

I have a report that pulls out all sales for certain dates,
my problem is: i have a field "amount",i need to count how many are at 299.99 and how many at 229.99 in 2 unbound-text box.
=IIF([amount]="299.99",count([amount])
Thanks...

 

[PaulBricker]

=Sum(IIF([amount]="299.99",1,0))

Try this. Summing zero's and one's is the same as counting.

Paul

 

[Monzer]

Thanks Paul but the result is 0(its not counting),i'm sure there's something missing.

 

[SgtJarrow]

Use:

=Sum(IIF([amount]=299.99,1,0))

Paul was close, but you were evualting for a string of 299.99.....the above will look for the number 299.99....
Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[Monzer]

Never mind Paul it works Thank you very much,you really helped me.

Thanks a lot.