Solved

Format field in Access 2003 query

Posted on 2010-08-17
2
413 Views
Last Modified: 2013-11-27
I have a field in an Access query

Interest: IIf([Interested]="Yes","Yes",([Percent]))

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
0
Comment
Question by:Pdeters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 4

Accepted Solution

by:
Scanman999 earned 500 total points
ID: 33456526
.0001 is in fact 0.01%

If you want it with decimals :
Interest: IIf([Interested]="Yes","Yes",format([Percent],"0%"))

or with 2 decimals :
Interest: IIf([Interested]="Yes","Yes",format([Percent],"0.00%"))

Cheers,
Andy
0
 
LVL 4

Expert Comment

by:Scanman999
ID: 33456543
.0001 is in fact 0.01%

If you want it WITHOUT decimals :
Interest: IIf([Interested]="Yes","Yes",format([Percent],"0%"))

or with 2 decimals :
Interest: IIf([Interested]="Yes","Yes",format([Percent],"0.00%"))

Cheers,
Andy
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question