ACCESS FEED: RE: [MS_AccessPros] Confusion with use of "Is Null" and :Nz"

Senin, 19 September 2011

RE: [MS_AccessPros] Confusion with use of "Is Null" and :Nz"

Robin,
Can you tell us anything about the validation rules? If you don't allow zero-length-strings you might want to set the criteria to
<>""

I would then update the records with the unwanted values to Null.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Tue, 20 Sep 2011 14:03:10 +1000
Subject: RE: [MS_AccessPros] Confusion with use of "Is Null" and :Nz"

I decided to test the process on the copy that is still on my machine
with this result:

http://www.rotary9790.org.au/test/test.asp

Should I proceed?

Robin

~~~~~~~~~~~~~~~~~~~~~~~~~~~ Original message ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks Graham,

Our database is resident on a remote server and I need to make the
changes when the keepers of the data are not working. Sunday was an
opportunity which I missed. Tomorrow I have another 'window of
opportunity' so please keep you fingers crossed for me.

Cheers,

Robin

At 19/09/2011 11:42 AM, you wrote:
>Hi Robin
>
>With the table in design view, select the field and, in the "Field
>Properties" pane at the bottom of the screen, ensure that both "Required"
>and "Allow Zero Length" are set to "No".
>
>Have you run the update queries as I suggested? If so, is your original
>query working as required?
>
>Cheers,
>Graham
>
> > From: MS_Access_Professionals@yahoogroups.com
>[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> > Sent: Monday, 19 September 2011 11:54
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: RE: [MS_AccessPros] Confusion with use of "Is Null" and :Nz"
> >
> > Many Thanks Graham,
> >
> > That was careless and shows my limitations. I copied the first query
> > and changed only the one reference. Now the results make sense.
> >
> > How do I change the table design to disallow ZLS fields?
> >
> > Regards,
> >
> > Robin Chapple
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>