Report

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
 
R

Ross

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
 
Top