Prev: Dividinglines property in Access reports
Next: Grouping
From: Hagan on 2 Jul 2008 16:17
Sorry if this is a repeat, but I think I posted it in the wrong area before.

I'm trying to use an Iif function between two columns that are populated in
the db. The lines total across, but when I try to grand total them att he
bottom, I get asked for more information or get an error.

=Sum(IIf([Monthly Limit]>[Total Points],[Total Points],[Monthly Limit]))

Thanks for any and all help.

From: Ken Snell (MVP) on 2 Jul 2008 22:38
Are [Monthly Limit] and [Total Points] the names of fields in the report's
RecordSource query? If not, replace them with the actual field names -- Sum
will not work on controls' values.

--

Ken Snell
<MS ACCESS MVP>


"Hagan" <Hagan(a)discussions.microsoft.com> wrote in message
news:1CE27F43-7230-462E-805C-AA3F38F7FE5B(a)microsoft.com...
> Sorry if this is a repeat, but I think I posted it in the wrong area
> before.
>
> I'm trying to use an Iif function between two columns that are populated
> in
> the db. The lines total across, but when I try to grand total them att he
> bottom, I get asked for more information or get an error.
>
> =Sum(IIf([Monthly Limit]>[Total Points],[Total Points],[Monthly Limit]))
>
> Thanks for any and all help.
>


 | 
Pages: 1
Prev: Dividinglines property in Access reports
Next: Grouping