Simple Expression - Fumbling Around

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably pretty simple, but I am clueless.

I am trying to write an expression so that a Sum on my report page will
default to $100 when the Sum is lower than that. I really don't know much
about writing expressions in general. I have this now:

=Sum([IPROJ_PREM])
 
Something like this:

=iif(Sum([IPROJ_PREM]) < $100, $100, Sum([IPROJ_PREM]))

HTH
 
Thank you - that works great!!

Douglas J. Steele said:
Try:

=IIf(Sum([IPROJ_PREM]) < 100, 100, Sum([IPROJ_PREM]))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Novice2000 said:
This is probably pretty simple, but I am clueless.

I am trying to write an expression so that a Sum on my report page will
default to $100 when the Sum is lower than that. I really don't know much
about writing expressions in general. I have this now:

=Sum([IPROJ_PREM])
Click to expand...
Click to expand...
 
Thank you - that works great. I guess I have a lot to learn...

Larry Daugherty said:
Something like this:

=iif(Sum([IPROJ_PREM]) < $100, $100, Sum([IPROJ_PREM]))

HTH
--
-Larry-
--

Novice2000 said:
This is probably pretty simple, but I am clueless.

I am trying to write an expression so that a Sum on my report page will
default to $100 when the Sum is lower than that. I really don't know much
about writing expressions in general. I have this now:

=Sum([IPROJ_PREM])
Click to expand...
Click to expand...
 
Back
Top