Exclude records that have a null field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I exclude records that will sum to zero in a report? 9
Nested Subreports and "Many to Many" Queries 1
how do I not show a record in a report when the total is zero? 1
Sum a field with null value 5
if it is null how not to get the #error 1
Average values excluding nulls and zeros 2
expression that excludes specified records 2
Excluding Certain Records from a report 1

Back
Top