Trying to omit empty records from appearing on Access report.

[enjay]

I created a simple access database with two tables, one query, and one report
that lists several different cost items per individual. Many of the records
contain $0 amounts. In the report, I would like to only show the fields that
contain more than $0 amounts and eliminate the space caused by the deletions.

 

[Stefan Hoffmann]

hi,

I created a simple access database with two tables, one query, and one report
that lists several different cost items per individual. Many of the records
contain $0 amounts. In the report, I would like to only show the fields that
contain more than $0 amounts and eliminate the space caused by the deletions.

Create a (inline) query for your report. Set a "> 0" as condition for
your amount fields.


mfG
--> stefan <--