SUM () GIVE ERROR

Z

zyus

I have a textbox in a datasheet with record source of :

=3*(IIf(Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0)*([tenure]-1)>[APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT],Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE]),0),Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0)))

If i try to sum it with another control like this

=Sum(3*(IIf(Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0)*([tenure]-1)>[APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT],Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE]),0),Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0))))

I get an error.

Any ideas?

Thank You
 
L

Larry Linson

Text Box in a Datasheet?

Could it be that you have a Text Box in a Form and are displaying it in
datasheet view, or you have a Calculated Field in a Query whose results you
are returning in Datasheet view? Please clarify.

Sounds suspiciously like something in a Report... in which you can't use a
Calculated Control in a Sum.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
 
Z

zyus

The text box is in a report.

Larry Linson said:
Text Box in a Datasheet?

Could it be that you have a Text Box in a Form and are displaying it in
datasheet view, or you have a Calculated Field in a Query whose results you
are returning in Datasheet view? Please clarify.

Sounds suspiciously like something in a Report... in which you can't use a
Calculated Control in a Sum.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP


zyus said:
I have a textbox in a datasheet with record source of :

=3*(IIf(Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0)*([tenure]-1)>[APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT],Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE]),0),Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0)))

If i try to sum it with another control like this

=Sum(3*(IIf(Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0)*([tenure]-1)>[APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT],Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE]),0),Round((([APPROVED_AMT]*[INT
RATE]*([TENURE]/12)+[APPROVED_AMT])/[TENURE])+0.499999,0))))

I get an error.

Any ideas?

Thank You
Click to expand...
Click to expand...
 
Top