Please Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database and have created the table, form and now I am on the queries. I am trying to add a new field in the query and when I add the fields to multiply, the query is only showing certain values. e
FL1Complete:[creditvalue2780] +[creditvalue2781]+[creditvalue111
The first two work no problem (creditvalue2780 and creditvalue2781) but as soon as I add the creditvalue111 field I only get information for the 111 field. Why would this be happening. Does anyone know
 
Hi,



Because NULL values propagates themselves through most arithmetic.

Nz(FL1Complete:creditvalue2780, 0) +Nz( creditvalue2781, 0)
+Nz(creditvalue111, 0)


Hoping it may help,
Vanderghast, Access MVP



Kirst said:
I am creating a database and have created the table, form and now I am on
Click to expand...
the queries. I am trying to add a new field in the query and when I add the
fields to multiply, the query is only showing certain values. eg
FL1Complete:[creditvalue2780] +[creditvalue2781]+[creditvalue111]
The first two work no problem (creditvalue2780 and creditvalue2781) but as
Click to expand...
soon as I add the creditvalue111 field I only get information for the 111
field. Why would this be happening. Does anyone know.
 
Back
Top