min value from 2 calculated text boxes on a report footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to input the minimum value from 2 calculated text boxes, CPU and CPL,
into the CPK text box.

All three text boxes are in the report footer. The CPU and CPL text boxes
are calculated from values from the report detail.

This is the code that I am using in the control source in the CPK text box:
=Min ([CPU],[CPL]). I get an error when the report is previewed.
I also tried the "smallest" in place of the "min" above to no avail.
Any ideas?
 
Min is an aggregate clause for SQL Statements.

try

=iif([CPU]<[CPL],[CPU],[CPL])

Mauricio Silva
 
Worked perfectly, thanks again!!

Mauricio Silva said:
Min is an aggregate clause for SQL Statements.

try

=iif([CPU]<[CPL],[CPU],[CPL])

Mauricio Silva

dirty70bird said:
Trying to input the minimum value from 2 calculated text boxes, CPU and CPL,
into the CPK text box.

All three text boxes are in the report footer. The CPU and CPL text boxes
are calculated from values from the report detail.

This is the code that I am using in the control source in the CPK text box:
=Min ([CPU],[CPL]). I get an error when the report is previewed.
I also tried the "smallest" in place of the "min" above to no avail.
Any ideas?
Click to expand...
Click to expand...
 
Back
Top