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!
-
date comparison between fields, show if greater than in red
Can't seem to get that to work. There are still certain dates that appear red when they shouldn't be. Additionally, when I converted to date value if there is nothing in the field there is an Error where nothing used to be. Where would I check to make sure PERRR1,etc. are un-normalized?- romann
- Post #6
- Forum: Microsoft: Access Reports
-
date comparison between fields, show if greater than in red
Duane, I suspected fields were treated as strings so where/how do I convert the values back to dates with Date Value() on the report? Thanks. romann- romann
- Post #4
- Forum: Microsoft: Access Reports
-
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
Thanks it worked great.- romann
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
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
