kermitforney
Technical User
Having a prickly problem that I can't seem to get past. I have a report in which a control source is used to calculate a sum, but now I would like it to be conditional. I just don't know how to make it so . . . )
Ex.
Actual Target %ofVisits
------ ------ ---------
4 4 100%
2 2 100%
1 1 100%
[red]2 1 200%[/red]
Sums
-------------------------------
9 8 112.5%
I would like the sum percent to treat any '%ofVisits' above 100% to be treated as 100% instead of '200%' like in the example. So basically I would not like the sum of %ofVisits to be above 100%.
In other words . . .
IF [%ofvisits] > 100% then [%ofvisits] = 100%
. . just don't know the correct syntax in Access.
FYI ~ I would still like for the '%ofVisits' to show that they were above 100%, I would just like for the sum to treat anything above 100% as 100%.
Ex.
Actual Target %ofVisits
------ ------ ---------
4 4 100%
2 2 100%
1 1 100%
[red]2 1 200%[/red]
Sums
-------------------------------
9 8 112.5%
I would like the sum percent to treat any '%ofVisits' above 100% to be treated as 100% instead of '200%' like in the example. So basically I would not like the sum of %ofVisits to be above 100%.
In other words . . .
IF [%ofvisits] > 100% then [%ofvisits] = 100%
. . just don't know the correct syntax in Access.
FYI ~ I would still like for the '%ofVisits' to show that they were above 100%, I would just like for the sum to treat anything above 100% as 100%.