[MS_AccessPros] Percents not working and not able to average

 

Good morning. I have a query that computes a ratio of Sold Price to Last Listed Price using the following:

Ratio: IIf([qCurrentPriceAll].[CurrentPrice]=0 Or [qCurrentPriceAll].[CurrentPrice] Is Null,"",[Sales]![SoldPrice]/[qCurrentPriceAll].[CurrentPrice])

On the report I would like it to display as a percentage. On the Property Sheet the Format for the field is Percent. (Percent is the only option given). I select 2 decimal points. An example of the result that shows is: 0.923248053392658 whether it's auto decimal places or 2 decimals. I want it to display 92.32%. What should I do?

Also, at the top of the report I tried to create a box that displayed the average ratio. The Control Source was set to = Avg([Ratio]). The message said that "the expression is typed incorrectly or is too complex to be evaluated ..."

Thank You!
Connie

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 1

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___