can someone help with this. I have 2 fields in a query
tbl1_nbil = 3
tbl2_nbil = 0
however when I add them using
Bill = [tbl1_nbil] + [tbl2_nbil], I only get a few of the added numbers in the calculated field. In some records it works, but in the majority it does not
It onl seems to add when both fields are greater than zero
tbl1_nbil : tbl2_nbil : Bill
1 : 1 : 2
1 : 0 : 0
2 : 1 : 3
0 : 2 : 0
4 : 0 : 0
tbl1_nbil = 3
tbl2_nbil = 0
however when I add them using
Bill = [tbl1_nbil] + [tbl2_nbil], I only get a few of the added numbers in the calculated field. In some records it works, but in the majority it does not
It onl seems to add when both fields are greater than zero
tbl1_nbil : tbl2_nbil : Bill
1 : 1 : 2
1 : 0 : 0
2 : 1 : 3
0 : 2 : 0
4 : 0 : 0
