Pdeters
asked on
Format field in Access 2003 query
I have a field in an Access query
Interest: IIf([Interested]="Yes","Ye s",([Perce nt]))
Interested is a text field and Percent is a field I want formatted like a percent. It is set up that way in the table but when put in this formula shows up as .0001 instead of 1%
how do I get Percent to format correctly
Interest: IIf([Interested]="Yes","Ye
Interested is a text field and Percent is a field I want formatted like a percent. It is set up that way in the table but when put in this formula shows up as .0001 instead of 1%
how do I get Percent to format correctly
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want it WITHOUT decimals :
Interest: IIf([Interested]="Yes","Ye
or with 2 decimals :
Interest: IIf([Interested]="Yes","Ye
Cheers,
Andy