Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Format field in Access 2003 query

Posted on 2010-08-17
2
Medium Priority
?
434 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
  • 2
2 Comments
 
LVL 4

Accepted Solution

by:
Scanman999 earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

572 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