ACCESS FEED: [MS_AccessPros] Re: #Error after Running Query

Jumat, 01 Februari 2013

[MS_AccessPros] Re: #Error after Running Query

I did try the ",Null" at the end of the formula and received an error message. In addition, I tried a a similar formula as the one you wrote John, but I used it in two different places in the formula and it came back with an error. I will also give this formula a try. Thanks for all the help!

v/r,
James Eggert

--- In MS_Access_Professionals@yahoogroups.com, John Viescas wrote:
>
> Good thinking, Liz. I would try this:
>
> TDA_Qty_Diff: IIF([FY13_TDA_TOTAL]=0 Or
> IsNull([FY13_TDA_TOTAL]),0,([FY13_TDA_TOTAL]-[FY08_TDA_TOTAL])/[FY13_TDA_TOT
> AL])
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> Sent: Friday, February 01, 2013 7:37 PM
> To: MS_Access_Professionals@yahoogroups.com'
> Subject: RE: [MS_AccessPros] Re: #Error after Running Query
>
> Would it crash if a null value is encountered?
>
> Respectfully,
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
> Sent: Friday, February 01, 2013 11:24 AM
> To: Access Professionals Yahoo Group
> Subject: RE: [MS_AccessPros] Re: #Error after Running Query
>
> I didn't think the expression was going to work as desired because of
> placement of ()s.
>
> I would have suggested:
> Expression: TDA_Qty_Diff:
> IIF([FY13_TDA_TOTAL]=0,0,([FY13_TDA_TOTAL]-[FY08_TDA_TOTAL])/[FY13_TDA_TOTAL
> ])
>
> Duane Hookom MVP
> MS Access
>
>
> > To: MS_Access_Professionals@yahoogroups.com
> > From: no_reply@yahoogroups.com
> > Date: Fri, 1 Feb 2013 17:27:33 +0000
> > Subject: [MS_AccessPros] Re: #Error after Running Query
> >
> >
> > Thanks Darrell! I had wrote a similar expression, but I was having a
> difficult time. I was missinf the section between =0,0, and -.
> >
> > V/r,
> > James Eggert
> > --- In MS_Access_Professionals@yahoogroups.com, "Embrey, Darrell" wrote:
> > >
> > > Expression: TDA_Qty_Diff: (IIf [FY13_TDA_TOTAL] =0, 0,
> [FY13_TDA_TOTAL]-[FY08_TDA_TOTAL])/[FY13_TDA_TOTAL]
> > >
> > > Darrell
> > >
> > > From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of j1eggert
> > > Sent: Friday, February 01, 2013 11:27 AM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] #Error after Running Query
> > >
> > >
> > >
> > > I created an expression to calculate the difference between to quantity
> fields and display as a negative or positive percentage. However, if the two
> fields have a value of zero the expression returns the #Error.
> > >
> > > Expression: TDA_Qty_Diff:
> ([FY13_TDA_TOTAL]-[FY08_TDA_TOTAL])/[FY13_TDA_TOTAL]
> > >
> > > How do I modify the expression to return a 0% instead of a #Error?
> > >
> > > Thanks for your help in advance!
> > >
> > > v/r,
> > >
> > > James Eggert
> > >
> > >
> > >
> > > The information contained in this communication is highly confidential
> and is intended solely for the use of the individual(s) to whom this
> communication is directed. If you are not the intended recipient, you are
> hereby notified that any viewing, copying, disclosure or distribution of
> this information is prohibited. Please notify the sender, by electronic mail
> or telephone, of any unintended receipt and delete the original message
> without making any copies.
> > >
> > > Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are
> nonprofit corporations and independent licensees of the Blue Cross and Blue
> Shield Association.
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended
> recipient(s) and may contain privileged and/or proprietary information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If you
> are not the intended recipient, please contact the sender by reply e-mail
> and destroy all copies of the original message.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>