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
|
|||
|
|||
conditional numeric formatting of field output on report
I have a report that uses one area to display either a percentage or a count
I'd like to format the report field output so that if the value is less than 1 to format the number as a 2 decimal point percent and if it is 1 or greater format it as an integer the conditional formatting features I see deal with the conditional display format and not the conditional numeric formatting I've struggled to see if I could conditionally format the data at the ControlSource point of the field properties or at the format point but have hit deadends on both avenues Jim- |
Thread Tools | |
Display Modes | |
|
|