Try
=IIf([ty_sis]>0,[ty_sis],Null)
" " is returning the space to a numeric field. Null should return
the null value and Access should recognize this as no data.
Good Luck
Hal
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
john sayre
<[EMAIL PROTECTED]
l.net> To
Sent by: AccessDevelopers@yahoogroups.com
AccessDevelopers@ cc
yahoogroups.com
Subject
RE: [AccessDevelopers] Make Zero
10/26/2005 02:24 blank -still gives error
PM
Please respond to
AccessDevelopers@
yahoogroups.com
This is just a double typo, the field name is correct on the report and
still fails.
This is too wierd...they are both numeric fields and none is null. I
tested this on other
fields with the same intermittent errors, some work, some do not
"Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> wrote:
Looks like I copied "sls" as "sis" -- must match an actual field, so that
may be what caused the error.
Tobi
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of john sayre
Sent: Wednesday, October 26, 2005 2:13 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Make Zero blank -still gives error
=IIf([ty_sis]>0,[ty_sis],"") gives "Error"
but =IIf([mtd_ly_ret]>0,[mtd_ly_ret],"") doesn't
"Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> wrote:
=iif([ty_sis]=0,"",[ty_sis])
No "then" or "else" needed.
Tobi
-----Original Message-----
From: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of bitschon
Sent: Wednesday, October 26, 2005 1:58 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Make Zero blank
If a value comes back to a text box that = 0, I want it to be blank.
I would think that soemthing like this would work:
=iif([ty_sls] = 0, then "",else [ty_sls])but it gives an error
How do I do this?
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
Microsoft access Microsoft access help Microsoft access
developer database
Microsoft access Microsoft access Microsoft access
training training course programming
YAHOO! GROUPS LINKS
Visit your group "AccessDevelopers" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
