=Sum with a max amount

[spacekowboy]

Hi, how can I put a max amount on an =sum box on a report? Lets say: =Sum([Paid]) with a max amount of $250,000.00 - or less than or equal to



Thanks

[ItsMe]

Maybe instead of an expression, you can use some VBA. Need to determine where to place the VBA by understanding where the unbound control resides within the report's structure. Header? Detail? Footer?

[spacekowboy]

It is in the Header

[ItsMe]

In the report's VBA module, there is an On Format section for each section. Select the Header from the lefthand puldown and the On Format from the right pull down within the VBA editor.

Your VBA goes in the new sub procedure.

Not sure what a max of 250K is all about but maybe an IF Then statement is in order. YOu could probably leave the expression in the textbox and simply use the .visible property or incorporate your expression into the VBA.

If me.ControlName < 250000 then
me.controlname.visble = True
else
me.controlname.visble = True
end if

[spacekowboy]

We ended up using an IF statement in the query on an alias field. and then summing the alias field on the report. Thanks for your reply