simple expression stumping me

[Dale]

I need to assign a value to a box on a form where X=A+B, but not to exceed Y.
To me it should be simple, but I’m being brain dead on this one. I don’t
see how to do the Max of Y.

 

[strive4peace]

Hi Dale,

can you use a specific example? ... don't have enough information to
help you ...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[fredg]

I need to assign a value to a box on a form where X=A+B, but not to exceed Y.
To me it should be simple, but I¢m being brain dead on this one. I don¢t
see how to do the Max of Y.

Your skimpy with the details, so here is a generic expression.

=IIf(A + B)>Y,Y,(A + B))

You can fill in the proper fields.

 

[Dale]

Hi Dale,

can you use a specific example? ... don't have enough information to
help you ...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

I said form, I meant report. I have five columns “count of Aâ€, “count of
Bâ€, “totalâ€, “Max allowed†, and "precent of allowed". I need the total of
A & B to be truncated at the value of Max allowed.

Thanks

 

[Dale]

Your skimpy with the details, so here is a generic expression.

=IIf(A + B)>Y,Y,(A + B))

You can fill in the proper fields.

That did it.

Thanks