SUM () GIVE ERROR

[Guest]

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

 

[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

 

[Guest]

The text box is in a report.

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

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