min value from 2 calculated text boxes on a report footer

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?
 
G

Guest

Min is an aggregate clause for SQL Statements.

try

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

Mauricio Silva
 
G

Guest

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...
 

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

Using Calculated Text Box Values in Report Footer Calculations 1
Show Parameter Information in Report Footer 1
Summing in a Report Footer 7
Report footer summing 1
Calculate Subreport totals in a main report Group footer 3
how do I sum a minimum value in a report? 1
Calculate a sum of subreports in main report 1
Using a Calculated Control in a Report 2

Top