Duane, Thanks for the heads up--It's working now! Right now every spare minute at work is consumed with getting this project to it's first "finished" state. Looking forward to having some spare time where I can read and learn more! And to being in a spot where I can do some Access at home.
Thanks again!
Connie
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> It's all about the "". John just answered a question for Robin within the last couple days pointing out the same exact issue.
> You should read through some of the other questions and answers in this group to learn from others' mistakes. That's how I learnt!
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: no_reply@yahoogroups.com
> Date: Wed, 21 Dec 2011 19:28:32 +0000
> Subject: Re: [MS_AccessPros] Percents not working and not able to average
>
>
>
>
>
>
> John--Percent is in the Format property of the control bound to Ratio on the report. Percent is the only option offered.
>
> I put the =Avg([Ratio}) in a control in the Report Footer and am still getting the same message.Could it have something to do with "" being put in the query's field where there is the CurrentPrice is Null or 0?
>
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Connie-
> >
> > Which property sheet? What is in the Format property of the control bound to
> > Ratio on the report? Percent should to it there.
> >
> > As for Avg, you can use that in a Group Footer or Report Footer, but not in a
> > Page Header.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Waco, Texas <yee haw>)
> >
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> > Sent: Wednesday, December 21, 2011 10:38 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [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
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar