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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
If statement help
Here is my if then statement - =IIf([SickBalance]>=240,240,[SickBalance]) What it currently does is determine how many sick hours a person has accrued. If it is greater than or equal to 240 hours it display the number 240 (this is the max amount you can accrue), if it is less than 240 hours...- romeyp
- Thread
- Replies: 15
- Forum: Microsoft: Access Reports
-
Formula and max value problem
I have a report I am trying to complete. This is the line that I am having a problem with. =IIf([Expr2]>=240,240,[Expr2]) This line feeds information into a text box on my report. Here is how it works - It is taking data from a vacation/sick report in the same database Expr2 represent the...- romeyp
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
Displaying/ stacking fields in a MS Access 2000 report
I am working on a report that keeps track of Vacation time, sick time, and holiday time available to our employees. I have it all set up but the problem I am having is this information is updated each month. I want to be able to show the balance from the previous month as well as the current...- romeyp
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
