Re: valores nulos en consulta

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

Article #101

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

#101

From: namor
Date: Thu, 16 Aug 2007 11:58

7 lines
1648 bytes

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 )

Technical Details

Message-ID: <1187265482.512178.37540@k79g2000hse.googlegroups.com>

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

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 111a5a,f80ef49fe3014a61
X-Google-Attributes: gid111a5a,public,usenet
X-Google-Language: SPANISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!k79g2000hse.googlegroups.com!not-for-mail
From:  namor <marco.pizzamiglio@gmail.com>
Newsgroups: es.comp.bd.ms-access
Subject: Re: valores nulos en consulta
Date: Thu, 16 Aug 2007 04:58:02 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <1187265482.512178.37540@k79g2000hse.googlegroups.com>
References: <1186038397.251452.233020@19g2000hsx.googlegroups.com>
NNTP-Posting-Host: 193.43.176.102
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1187265482 1730 127.0.0.1 (16 Aug 2007 11:58:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 16 Aug 2007 11:58:02 +0000 (UTC)
In-Reply-To: <1186038397.251452.233020@19g2000hsx.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 cache.comune.gorizia.it:3030 (squid/2.6.STABLE13-20070515), 1.0 cache.comune.gorizia.it:3128 (squid/2.6.STABLE13-20070515), 1.0 proxy-sial (NetCache NetApp/5.5R5D8)
Complaints-To: groups-abuse@google.com
Injection-Info: k79g2000hse.googlegroups.com; posting-host=193.43.176.102;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0

Reply to Parent Message