If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
min value from 2 calculated text boxes on a report footer
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? |
#2
|
|||
|
|||
Min is an aggregate clause for SQL Statements. try =iif([CPU][CPL],[CPU],[CPL]) Mauricio Silva "dirty70bird" wrote: 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? |
#3
|
|||
|
|||
Worked perfectly, thanks again!!
"Mauricio Silva" wrote: Min is an aggregate clause for SQL Statements. try =iif([CPU][CPL],[CPU],[CPL]) Mauricio Silva "dirty70bird" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with Calculated Control in Report | Jere Shaw | General Discussion | 2 | December 19th, 2004 11:17 PM |
Dynamic Heading in cross tab qry report | ECA | Setting Up & Running Reports | 3 | December 13th, 2004 11:09 PM |
text boxes are linked even though Word doesn't think they're linked | Barbara White | Formatting Long Documents | 2 | October 18th, 2004 06:07 PM |
adding value in text boxes on report | don | Setting Up & Running Reports | 4 | August 28th, 2004 04:12 AM |
Printing Text Boxes with a chart | Jon Peltier | Charts and Charting | 1 | January 12th, 2004 01:51 PM |