Report

  • Thread starter Thread starter Debra
  • Start date Start date
D

Debra

I have a report based on a query. some of the calculated
values are less than one. I would like to have those
values default to 1 in the report.

Thanks for your help
 
Hi Debra

You could just amend the query along these lines:

Create New Field:
iif(fld1 < 1, 1, fld1)

Alternatively in the Report, if you didn't want to amend the query:

Create new text box:
For the ControlSource property:

iif(fld1 < 1, 1, fld1)

I hope that answer is OK

Kind regards

Ross Petersen
 
Back
Top