Changing Numeric Format by Row

G

Guest

I have a report that list the following:

Category Jan 07 Feb 07 Mar 07
LH 1.1600 1.1700 1.1800
RT 4.700 4.800 4.900
CB .0854 .0854 .0855

Each row should be formated differently. Can the report be made to look
like this and if so, in what event would it be coded and how would the
format be set ?

Category Jan 07 Feb 07 Mar 07
LH 1.16 1.17 1.18
RT 4.7 4.8 4.9
CB 8.54% 8.54% 8.55%
 
G

Guest

In the text box control souce write

=IIf([category]="LH",Format([MyNum],"#.00"),IIf([category]="RT",Format([mynum],"#.0"),Format([mynum],"#.00%")))

In any way, you can play with ths idea to change the format of the field
 
G

Guest

It Worked ! Thank you.

Ofer Cohen said:
In the text box control souce write

=IIf([category]="LH",Format([MyNum],"#.00"),IIf([category]="RT",Format([mynum],"#.0"),Format([mynum],"#.00%")))

In any way, you can play with ths idea to change the format of the field

--
Good Luck
BS"D


rmcompute said:
I have a report that list the following:

Category Jan 07 Feb 07 Mar 07
LH 1.1600 1.1700 1.1800
RT 4.700 4.800 4.900
CB .0854 .0854 .0855

Each row should be formated differently. Can the report be made to look
like this and if so, in what event would it be coded and how would the
format be set ?

Category Jan 07 Feb 07 Mar 07
LH 1.16 1.17 1.18
RT 4.7 4.8 4.9
CB 8.54% 8.54% 8.55%
Click to expand...
Click to expand...
 
Top