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

Selasa, 20 September 2011

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

Duane,

The validation rules for new entries do not allow ZLS but the dirty
data was inherited from a variety of sources. The suggestions by
Graham have cleaned up that problem. Thanks for your interest.

Regards,

Robin Chapple

At 20/09/2011 03:45 PM, you wrote:

>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
> >
> >
> >
>
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>