Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Control Source - calculated values 1

Status
Not open for further replies.

kermitforney

Technical User
Mar 15, 2005
374
US
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 . . . :eek:)

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%.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top