Nulls giving a lot of trouble

[sonaljain123]

Debug.Print also gave me syntax error like missing bracket or a colon.

So just to be absolutely clear, when you mean copy, do you mean just copy the table and set the validation rule or something?

Sorry I think I am still new to access so facing all these problems...

Thank you!

 

[pbaldy]

What was the SQL produced by the Debug.Print?

I meant to copy the table and then set the Required and Allow Zero Length properties for each field (the Allow Zero Length will only show up for text fields). That said, I suspect it will not solve your problem, as you'd end up losing those records (they would fail to append).

 

[sonaljain123]

yeah I dont think that is still working. So basically the problem is that for example from that master table, using a query I am getting three columns and I am trying to get a sum of those three columns in the fourth column. Since values in two of those columns is zero or Null (not sure), the sum is also zero or Null even though the third column is a non zero value.

So do you think it is surely the problem of nulls only> I dont see anything else going wrong here.

Thanks!

 

[sonaljain123]

Hi, I think I was able to fix the problem of nulls with the Nz modification in my query so it is working fine now.

Thank you!

 

[pbaldy]

Glad we got it sorted out.