From: Jodie on 18 Mar 2010 13:08 I need to do an update to change all blank fields to a 0 (zero). In the criteria, I have tried IsNull and it is not returning any of the blank records. I have tried IsEmpty and I get a message that say mismatch. What can I enter in the criteria that will recognize all of the blank fields? -- Thank you, Jodie
From: KARL DEWEY on 18 Mar 2010 13:24 >>What can I enter in the criteria that will recognize all of the blank fields? There are more than one thing that can appear as a blank. There are nulls and zero lenght strings. Use this to pull both -- Is Null OR "" That is two double quotes. -- Build a little, test a little. "Jodie" wrote: > I need to do an update to change all blank fields to a 0 (zero). In the > criteria, I have tried IsNull and it is not returning any of the blank > records. I have tried IsEmpty and I get a message that say mismatch. What > can I enter in the criteria that will recognize all of the blank fields? > -- > Thank you, Jodie
From: John W. Vinson on 18 Mar 2010 13:26 On Thu, 18 Mar 2010 10:08:01 -0700, Jodie <Jodie(a)discussions.microsoft.com> wrote: >I need to do an update to change all blank fields to a 0 (zero). In the >criteria, I have tried IsNull and it is not returning any of the blank >records. I have tried IsEmpty and I get a message that say mismatch. What >can I enter in the criteria that will recognize all of the blank fields? Is Null The blank is significant. IS NULL is a SQL criterion; IsNull() is a VBA function. They are confusingly similar in both name and functionality but they are not identical! -- John W. Vinson [MVP]
From: Jodie on 18 Mar 2010 15:28 I thank you Karl. Apparently, I was not putting a space in between Is and Null. It is working fine now. -- Jodie "KARL DEWEY" wrote: > >>What can I enter in the criteria that will recognize all of the blank fields? > There are more than one thing that can appear as a blank. There are nulls > and zero lenght strings. > Use this to pull both -- > Is Null OR "" > That is two double quotes. > > -- > Build a little, test a little. > > > "Jodie" wrote: > > > I need to do an update to change all blank fields to a 0 (zero). In the > > criteria, I have tried IsNull and it is not returning any of the blank > > records. I have tried IsEmpty and I get a message that say mismatch. What > > can I enter in the criteria that will recognize all of the blank fields? > > -- > > Thank you, Jodie
From: Abki on 20 Mar 2010 11:07
Doubble qoutes, null or space are all diffrent. Double qoutes means the field have data with binary zero. (asci x'00') Space means field have data as space not binary zero but code X'20' in asci. Nulls is not represented in data field. Its indicated that field isnt initiated. "KARL DEWEY" skrev: > >>What can I enter in the criteria that will recognize all of the blank fields? > There are more than one thing that can appear as a blank. There are nulls > and zero lenght strings. > Use this to pull both -- > Is Null OR "" > That is two double quotes. > > -- > Build a little, test a little. > > > "Jodie" wrote: > > > I need to do an update to change all blank fields to a 0 (zero). In the > > criteria, I have tried IsNull and it is not returning any of the blank > > records. I have tried IsEmpty and I get a message that say mismatch. What > > can I enter in the criteria that will recognize all of the blank fields? > > -- > > Thank you, Jodie |