Creating Criteria in a Report

[orbus]

I need some help on setting criteria for records in a report. Basically, I have two controls: a name from a table, and then a calculated fields which calls on a bunch of queries, using the name control as the variable.

What i want to do is if the calculated control equals zero, i don't want that record to show on the report. So basically i get just the data greater than zero.

I know that i can do this through creating more queries... so don't suggest that... if i could do it right from the report that'd be mint.

any suggestions?

thanks!

 

[JoeMiller]

It's hardly proper to do but you can use iif statements to do what you want.

=iif([FieldToCheck]=0,"",[FieldToShow])

Again this should really be done in the query because of the speed difference but hey, maybe there's a good reason!
Joe Miller
joe.miller@flotech.net