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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.