Re: valores nulos en consulta

Article View: es.comp.bd.ms-access

Article #110

Back to es.comp.bd.ms-access Previous Next

#110

From: jorgejhum
Date: Fri, 12 Oct 2007 16:47

21 lines
1966 bytes

On 16 ago, 08:58, namor <marco.pizzamig...@gmail.com> wrote:
> On 2 Ago, 09:06, loquillo <jesusl...@gmail.com> wrote:
>
> > quiero saber un codigo para que cuando el valor sea nulo me aparezaca
> > 0 en vez de no aparecer nada
>
> Ve nz() en el help <F1>.
>   = nz( valor , 0 )
>   = nz( valor ; 0 )

--------
En mi  experiencia diaria utlizo nz o la funcion SiInm.

Ejemplo en un campo numerico (Dentro del criterio de la consulta )

Total:SiInm(Esnulo([nombredelcampo]),0,[nombredelcampo])

(En el caso de ",0," , segun la configuracion de tu windows serà "," ò
" ; ")

Saludos :; NATIVO !

Technical Details

Message-ID: <1192207656.517638.312080@e34g2000pro.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!e34g2000pro.googlegroups.com!not-for-mail

References: <1186038397.251452.233020@19g2000hsx.googlegroups.com> <1187265482.512178.37540@k79g2000hse.googlegroups.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 111a5a,f80ef49fe3014a61
X-Google-Attributes: gid111a5a,public,usenet
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!e34g2000pro.googlegroups.com!not-for-mail
From:  jorgejhum@gmail.com
Newsgroups: es.comp.bd.ms-access
Subject: Re: valores nulos en consulta
Date: Fri, 12 Oct 2007 16:47:36 -0000
Organization: http://groups.google.com
Lines: 31
Message-ID: <1192207656.517638.312080@e34g2000pro.googlegroups.com>
References: <1186038397.251452.233020@19g2000hsx.googlegroups.com>
   <1187265482.512178.37540@k79g2000hse.googlegroups.com>
NNTP-Posting-Host: 200.11.112.214
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1192207687 28349 127.0.0.1 (12 Oct 2007 16:48:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 12 Oct 2007 16:48:07 +0000 (UTC)
In-Reply-To: <1187265482.512178.37540@k79g2000hse.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a9pre) Gecko/2007100304 Minefield/3.0a9pre,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 RELAY
Complaints-To: groups-abuse@google.com
Injection-Info: e34g2000pro.googlegroups.com; posting-host=200.11.112.214;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0

Reply to Parent Message