ControlSource for TextBox

[cwstektips]

Why won't the following work as the ControlSource for a TextBox in the Report Footer?

=Sum(IIf([PrtCd]=1,[AdjCash],0))

Produces the following error message:
2589: The expression 'Sum(IIf([PrtCd]=1,[AdjCash],0))' is invalid.

 

[PaulBricker]

What datatype are PrtCd and AdjCash? There really isn't anything wrong with the expression. It should work just fine if PrtCd and AdjCash are not calculated textboxes in your Report.

Paul

 

[cwstektips]

PrtCd is int and AdjCash is dec. They are both fields in the recordset used as the RecordSource for the report. I'm doing an Access Project (SQL Server 2000 backend for data). I agree it should work. I've done a "workaround" but at this point am just curiuos as to why it doesn't work.
Thanks

 

[PaulBricker]

Well, if this is an .adp file, I would say the IIF probably doesn't work although it could be either. I don't know for sure and I'd have to check this evening, but I know the Int() function won't work in an .adp app so it's possible one or both of those two functions isn't available either.
They might know over here

forum958


Paul