Sumation

[Henrikas]

Hello. I have 1 problem. I want to sum fields of numbers where it is formated
by IIf sentences. Therefore it can not be done, because IIf sentence is
written in "control source" (table doesn't save that number) and it is
impossible to write it in "Default value", sum is always 0.
Let's say i have 500 fields with IIf sentence in it "IIf ([XXX]=True;
a*b;b*c)" . And i need to sum all those results. How to do that?

 

[John W. Vinson]

Hello. I have 1 problem. I want to sum fields of numbers where it is formated
by IIf sentences. Therefore it can not be done, because IIf sentence is
written in "control source" (table doesn't save that number) and it is
impossible to write it in "Default value", sum is always 0.
Let's say i have 500 fields with IIf sentence in it "IIf ([XXX]=True;
a*b;b*c)" . And i need to sum all those results. How to do that?

Put the IIF() statement *in a calculated field in a Query*, rather than in the
control source of a textbox on a form. You can then sum the calculated field
in the query.