Losing % Format in Query

[AJR]

Hi

Very new to Access and have just encountered this problem, which I cannot seem to resolve.

I have a table [Cat1] which includes a field [Target%]. If I use this field alone in a query the % format will be maintained. However, if I use the field as part of this expression:

IIf([Assets]![AssetType]="Stock",[Cat1]![Target%],"")

The result will be displayed as a decimal. So, if I enter the [Target%] as 90% in the Table, and use that field in the above expression, the result will be displayed as .9

I am using the query as the record source of a report and thought I could simply apply the % format there, but, in report design view the number formatting is disabled for that field.

Would really appreciate any ideas you may have.

Thanks in advance

AJR

 

[plog]

Use the Format function: http://www.techonthenet.com/access/functions/string/format.php

 

[AJR]

Thanks Plog. Easy to accomplish and a good future reference.

AJR