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!
-
IIf Statements in Reports
Alex & Nick, Thank you very much for your replies. The IIF statement still doesn't run when I write this in the report. Should it be done in a query. If so, how? Thanks- ScoobyDew
- Post #4
- Forum: Microsoft: Access Other topics
-
Microsoft Access Form Page length
In order to print one customer per page, you will have to select the detail bar in the Report design screen. Just click the bar that contains the "Detail" section (It should turn black once it is selected). Right click this bar and select "Properties". A dialogue box titled...- ScoobyDew
- Post #3
- Forum: Microsoft: Access Other topics
-
IIf Statements in Reports
I created an Attendance report that sorts by individual employees. In the footer section for each employee I used the COUNT function to tally the number of attendance occurences that each employee has. I need to be able to have a disciplinary step printed out in the footer for each employee...- ScoobyDew
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
-
IIF function
I made a report that totals the number of absences for each employee. How do I get the report to print a certain type of response based on the number of absences. For example, if an employee totals 4 absences then I need the word "Verbal" to appear on the report next to that...- ScoobyDew
- Post #3
- Forum: Microsoft: Access Other topics
