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

Minggu, 18 September 2011

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

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