Feild Null to "0"

  • Thread starter Thread starter Keith
  • Start date Start date
Please rephrase the queestion.

If you're trying to check if a field is null, use the function IsNull().
If you want to convert Nulls to Zero or a zero length string use the
Function NZ().

HTH,
Josh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Adding values in two feilds based on condition 1
Return 0 when value is Null 1
Auto Update a feild every year 2
<= 0 11
incorrect null value in combobox 5
Replace "0" with a blank space 7
How to preserve null value in a access calculated field using iif 3

Back
Top