Go Back   Access World Forums > Search Forums

 
Showing results 1 to 9 of 9
Search took 0.03 seconds.
Search: Posts Made By: BernieAnne
Forum: Tables 03-03-2018, 03:38 PM
Replies: 19
Views: 1,241
Posted By CJ_London
Re: "Is null" not working in Tables

Although I haven't done any testing to prove the point I believe there is another benefit of using nulls rather than zls in certain situations - indexing.

indexes can be set to ignore nulls,...
Forum: Tables 03-03-2018, 03:13 PM
Replies: 19
Views: 1,241
Posted By The_Doc_Man
Re: "Is null" not working in Tables

I agree with Pat though there was a spirited debate about use of null, zero, and "" (the empty string) for various reasons.

My own viewpoint of dates is that for MOST modern things, a date of zero...
Forum: Tables 03-01-2018, 08:30 AM
Replies: 19
Views: 1,241
Posted By Pat Hartman
Re: "Is null" not working in Tables

I prefer to never allow ZLS in my text fields because of the confusion. Various versions of Access have over the years vacillated on the default. I'm pretty sure that the default setting for...
Forum: Tables 03-01-2018, 07:14 AM
Replies: 19
Views: 1,241
Posted By The_Doc_Man
Re: "Is null" not working in Tables

True that ISNULL is preferred for VBA, RANMAN. However, you CAN say "IF X IS NULL" in VBA and it will work, since it is possible in VBA to have a Variant type variable that is null. The IS NULL...
Forum: Tables 03-01-2018, 06:54 AM
Replies: 19
Views: 1,241
Posted By Ranman256
Re: "Is null" not working in Tables

IS NULL
is for query criteria

IsNull(field) is for vb code
Forum: Tables 03-01-2018, 06:24 AM
Replies: 19
Views: 1,241
Posted By The_Doc_Man
Re: "Is null" not working in Tables

CJ pointed out the important difference: Some time after Ac2002, Access's database engine was upgraded from something called Jet to a new engine called Ace. Here are your syntax choices for SQL,...
Forum: Tables 03-01-2018, 01:02 AM
Replies: 19
Views: 1,241
Posted By CJ_London
Re: "Is null" not working in Tables

try finding 'null', rather than 'is null'

works for me on numeric fields

as to why it is different - your old db uses JET, modern ones use ACE, a different db engine so there may be some...
Forum: Tables 02-28-2018, 07:25 PM
Replies: 19
Views: 1,241
Posted By The_Doc_Man
Re: "Is null" not working in Tables

As Colin points out, there are two possible 'values' that look alike. A zero-length string (also called an empty string) can be detected with IsEmpty(). A null field would occur only if the method...
Forum: Tables 02-28-2018, 03:50 PM
Replies: 19
Views: 1,241
Posted By isladogs
Re: "Is null" not working in Tables

An empty or zero length string (ZLS) is not the same thing as null

If you want to update empty strings to Null, use an update query filtering for "" and updating to Null
Showing results 1 to 9 of 9

 
Forum Jump



All times are GMT -8. The time now is 01:23 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World