null value

D

Delf

in my report I have 2 fields with amount in them and if
this amount is equal to zero I don't want it to show on
the report. I do I do that?
Tx
 
R

Rick B

I would calculate the result in my query upon which the form is based.
Something like...

NewValue: [Field1] + [Field2]


Then, in the criteria for that new field, put <>0


Rick B
 

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

Creating a Chart on form from selected data in query. 0
multiple conditions 8
Mail Merge - displaying a conditional number of decimals 5
Like to start using Access 1
Expression that has no Value 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
200KB versus 35MB 0
Script MT bold 0

Top