RE: [MS_AccessPros] not sure how to say this....

If the field is numeric, you can set the format property to a value that displays "NA" if the value is 0.

Duane Hookom
MS Access MVP

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: cc0623@yahoo.com
> Date: Tue, 11 Oct 2011 15:15:33 -0700
> Subject: Re: [MS_AccessPros] not sure how to say this....
>
>
>
> I just changed the NA to a 0 and the field caluculates 0 now. I was
> hoping for it to say NA but oh well. On to harder things.
>
> Thanks anyway.
>
> Tiffany Atchley
> PO Box 1003
> Fort Duchesne, UT 84026
> 435-722-7833
> WWW.ODYSSEYMINISHETLANDS.NET
>
> ________________________________
> From: Liz Ravenwood
> <liz_ravenwood@beaerospace.com<mailto:liz_ravenwood%40beaerospace.com>>
> To:
> "'MS_Access_Professionals@yahoogroups.com<mailto:%27MS_Access_Professionals%40yahoogroups.com>'"
> <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>>
> Sent: Tuesday, October 11, 2011 3:55 PM
> Subject: RE: [MS_AccessPros] not sure how to say this....
>
>
> Could your recordsource for the form be based on a query that
> calculates the field by:
>
> CalcResult: Iif(LastMonth="NA",0,[LastMonth])
>
> Liz Ravenwood
> Database Developer / Programmer
> 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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>]
> On Behalf Of cc0623
> Sent: Tuesday, October 11, 2011 2:29 PM
> To:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] not sure how to say this....
>
> a form
>
> Tiffany Atchley
> PO Box 1003
> Fort Duchesne, UT 84026
> 435-722-7833
> WWW.ODYSSEYMINISHETLANDS.NET
>
> ________________________________
> From: Liz Ravenwood
> <liz_ravenwood@beaerospace.com<mailto:liz_ravenwood%40beaerospace.com>>
> To:
> "'MS_Access_Professionals@yahoogroups.com<mailto:%27MS_Access_Professionals%40yahoogroups.com>'"
> <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>>
> Sent: Tuesday, October 11, 2011 3:27 PM
> Subject: RE: [MS_AccessPros] not sure how to say this....
>
> Is this for a report or a form?
>
> Liz Ravenwood
> Database Developer / Programmer
> 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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>]
> On Behalf Of cc0623
> Sent: Tuesday, October 11, 2011 2:22 PM
> To:
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] not sure how to say this....
>
> I need to do conditional formatting for a column. I want it place o in
> the calculated field if Last month is NA.
>
> So...
>
> Total is 0 if Last month is NA.
>
> How do I say this????
>
> ------------------------------------
>
> 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.
>
> [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.
>
> [Non-text portions of this message have been removed]
>
>
>

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/