Force Zeros into inmatched fields in Append Process

[John Baker]

Hi:

I have a situation where I am appending records to a table, and some of the records do NOT
have all the fields in them that the table has. In those cases, the field is filled with a
null but the normal append process. Does anyone know of an easy way to force the use of a
0 (zero) rather than a null when fields don't match on an append? It would make life much
easier down the line where I haver to do summing and things, and sometimes null doesn't
behave exactly the same as a zero!

Thanks

John Baker

[Salad]

John Baker wrote:

Hi:

I have a situation where I am appending records to a table, and some of the records do NOT
have all the fields in them that the table has. In those cases, the field is filled with a
null but the normal append process. Does anyone know of an easy way to force the use of a
0 (zero) rather than a null when fields don't match on an append? It would make life much
easier down the line where I haver to do summing and things, and sometimes null doesn't
behave exactly the same as a zero!

Thanks

John Baker

Use an expression
IIF(Nz([Field],0) > 0,[Field],0)

Of course, you could set the DefaultValue to zero in the table...or else in the form.

[John Baker]

Thanks:

Of course..its a table.. set the default to zero!

I should have through of that!

Thanks

John

Salad <oi*@vinegar.com> wrote:

John Baker wrote:

Hi:

I have a situation where I am appending records to a table, and some of the records do NOT
have all the fields in them that the table has. In those cases, the field is filled with a
null but the normal append process. Does anyone know of an easy way to force the use of a
0 (zero) rather than a null when fields don't match on an append? It would make life much
easier down the line where I haver to do summing and things, and sometimes null doesn't
behave exactly the same as a zero!

Thanks

John Baker

Use an expression
IIF(Nz([Field],0) > 0,[Field],0)

Of course, you could set the DefaultValue to zero in the table...or else in the form.