The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet. Your reply message has not been sent.
Your post was successful
 |
Newsgroups: microsoft.public.access
From: "mohsin via AccessMonster.com" <u31851@uwe>
Date: Wed, 04 Nov 2009 12:38:08 GMT
Local: Wed, Nov 4 2009 11:38 pm
Subject: Is null, for empty value
Hi need your help please,
my queries to replace "empty" input as "0" values as below:
LOGICAL: IIf([tbl_A]![LOGICALA] Is Null,"0",[tbl_A]![LOGICALA])
the result is no change. meaning still as "empty" instead replace the value
as "0"
thank you, Mohsin
--
Cheers
Mohsin
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200911/1
You must Sign in before you can post messages. You do not have the permission required to post.
|
|
Newsgroups: microsoft.public.access
From: "kc-mass" <connearney_AT_comcast_DOT_net>
Date: Wed, 4 Nov 2009 08:11:34 -0500
Local: Thurs, Nov 5 2009 12:11 am
Subject: Re: Is null, for empty value
Two options: LOGICAL: IIf(IsNull([tbl_A]![LOGICALA]),0,[tbl_A]![LOGICALA])
OR
LOGICAL: NZ([tbl_A]![LOGICALA],0)
Regards
Kevin
"mohsin via AccessMonster.com" <u31851@uwe> wrote in message
news:9e9c5e09cdb07@uwe...
> Hi > need your help please,
> my queries to replace "empty" input as "0" values as below:
> LOGICAL: IIf([tbl_A]![LOGICALA] Is Null,"0",[tbl_A]![LOGICALA])
> the result is no change. meaning still as "empty" instead replace the
> value
> as "0"
> thank you, Mohsin
> --
> Cheers
> Mohsin
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/200911/1
You must Sign in before you can post messages. You do not have the permission required to post.
|
|
Newsgroups: microsoft.public.access
From: KARL DEWEY <KARLDE...@discussions.microsoft.com>Date: Thu, 5 Nov 2009 15:06:01 -0800
Local: Fri, Nov 6 2009 10:06 am
Subject: RE: Is null, for empty value
Maybe they are not null so try this -- LOGICAL: IIf([tbl_A].[LOGICALA] Is Null OR [tbl_A].[LOGICALA] = "","0",[tbl_A].[LOGICALA]) --
Build a little, test a little.
"mohsin via AccessMonster.com" wrote: > Hi > need your help please,
> my queries to replace "empty" input as "0" values as below:
> LOGICAL: IIf([tbl_A]![LOGICALA] Is Null,"0",[tbl_A]![LOGICALA])
> the result is no change. meaning still as "empty" instead replace the value
> as "0"
> thank you, Mohsin
> --
> Cheers
> Mohsin
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/200911/1
> .
You must Sign in before you can post messages. You do not have the permission required to post.
|
|
Newsgroups: microsoft.public.access
From: "mohsin via AccessMonster.com" <u31851@uwe>
Date: Sat, 07 Nov 2009 14:38:48 GMT
Local: Sun, Nov 8 2009 1:38 am
Subject: RE: Is null, for empty value
Thanks karl, rgds, Mohsin
KARL DEWEY wrote: >Maybe they are not null so try this -- >LOGICAL: IIf([tbl_A].[LOGICALA] Is Null OR [tbl_A].[LOGICALA] = >"","0",[tbl_A].[LOGICALA]) >> Hi
>[quoted text clipped - 7 lines]
>> thank you, Mohsin
-- Cheers Mohsin Message posted via http://www.accessmonster.com
You must Sign in before you can post messages. You do not have the permission required to post.
|
|
|
|
