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!

Register Log in
  • 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!

"Capping" a field at 100%

Status
Not open for further replies.
wayneryeven

wayneryeven

Technical User
May 21, 2004
101
GB
Hi All
I have a text box that performs a calculation in a report, it is a sub category calculation hence cant be done in the query. The problem is that is calculates a percentage, but what i want to do is cap it at 100% i.e. the result can never be more than 100% (even though it may well be).

Can this be done on the report?

Many Thanks
 
Sort by date Sort by votes
Something like this then? IIF([YourCalculation]>1,1,[YourCalculation])
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
298
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
170
sxschech
sxschech
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
448
caykamanj1966
caykamanj1966
RonMcIntire
  • Locked
  • Question
Adding variables to a control in a footer 1
Replies
4
Views
179
sxschech
sxschech
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
108
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top