Greetings everyone! I have a query that gets the max field length number.
If the field is null, then there is no value. How do I update the null to a
zero? Below is the code.


SELECT Max(Len([fnm])) AS FNM1, Max(Len([lnm])) AS Lnm2 FROM uppercustomer;

SELECT Max(Len(Nz([fnm], ""))) AS FNM1, Max(Len(Nz([lnm], ""))) AS Lnm2 FROM
uppercustomer

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ray Mead" <(E-Mail Removed)> wrote in message
news:42AD773C-35A4-494C-9F9A-(E-Mail Removed)...
> Greetings everyone! I have a query that gets the max field length number.
> If the field is null, then there is no value. How do I update the null to
> a
> zero? Below is the code.
>
>
> SELECT Max(Len([fnm])) AS FNM1, Max(Len([lnm])) AS Lnm2 FROM
> uppercustomer;
>

thanks for the helpful post, it works like a charm!!!

"Douglas J. Steele" wrote:

> SELECT Max(Len(Nz([fnm], ""))) AS FNM1, Max(Len(Nz([lnm], ""))) AS Lnm2 FROM
> uppercustomer
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Ray Mead" <(E-Mail Removed)> wrote in message
> news:42AD773C-35A4-494C-9F9A-(E-Mail Removed)...
> > Greetings everyone! I have a query that gets the max field length number.
> > If the field is null, then there is no value. How do I update the null to
> > a
> > zero? Below is the code.
> >
> >
> > SELECT Max(Len([fnm])) AS FNM1, Max(Len([lnm])) AS Lnm2 FROM
> > uppercustomer;
> >
>
>
>