Format Function in Query Field Doesn't Work

[Steve in Wisconsin]

Hello,

I have successfully created a field in a crosstab query
that joins two pieces of information. However no matter
what I try I can't get the format function to apply to the
field. Here is the string:

Rank & Result: First([Rank] & Chr(13) & Chr(10) & IIf
([endofweekresult]>0,Format
([endofweekresult],"#,##0.00%"),Format
([endofweekresult],"0.00%[Red]")))

The percent format does work however the [Red] color won't
apply itself. ???

Any help would be appreciated.

 

[Duane Hookom]

The only time I have seen the color work is in the format property of a
control.