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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
date comparison between fields, show if greater than in red
I have a report which lists the project name and several dates as column headings which I use to track the status of projects. I would like to compare two columns of dates and if a date in the first column [In] is greater than the second column [Out] the font in the first column switches to...- romann
- Thread
- Replies: 6
- Forum: Microsoft: Access Reports
-
Nested IIf statement does not retrieve all information
I am trying to set up a status field within a query where only the latest date of the following three fields appears, but the PERRR1 and PERRR2 fields may or may not any have an entry. PERReceived PERRR1 PERRR2 So if PERRR2 is not entered then it should enter PERRR1 and if PERRR1 that isn't...- romann
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
