Remove Null values and fields with Zero

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have a report that I created as a result of an unmatched
query if looks like this.



ImpactGrant# Applid FutYr1) FutYr 1(Noncom) Fut1 Diff
(IMPACT)

789265-01 12574 $220,000 $220,000 $0
778989-02 23457 $585,000 $585,000 $0


I would like to remove all the records that have a zero or
null value within my report. How can I accomplish this
task?
 
Do you want it just on this one field? You could set a filter in the report
or use criteria in the query supplying the data to remove values of this
type.
 
Allison said:
I have a report that I created as a result of an unmatched
query if looks like this.



ImpactGrant# Applid FutYr1) FutYr 1(Noncom) Fut1 Diff
(IMPACT)

789265-01 12574 $220,000 $220,000 $0
778989-02 23457 $585,000 $585,000 $0


I would like to remove all the records that have a zero or
null value within my report. How can I accomplish this
task?
Click to expand...


Add a criteria to the query to filter out the zero values.

Or, alternatively, use the OpenReport method's
WhereCondition argunment.
 
Back
Top