Exclude records that have a null field

[emc]

I have a report where people are listed with [Shares] in various companies.
Some have recently sold their shares and are now at zero. When I run the
report they are listed as zero but as I have a sum total of shareholders and
shares at the bottom I do not want them to be listed at all.

Any help would be greatly appreciated on this.

Many thanks.

emc

 

[Duane Hookom]

Is there a reason why you can't just set a criteria in the report's record
source query?