How would I write it if I want a "datedue" column to auto pop a value of 365 days later than "datetaken" column but only if "CourseTitle"column = CourseA?
Competent Performer
Windows XP 
Access 2010 (version 14.0)
Conditional Formatting
How would I write it if I want a "datedue" column to auto pop a value of 365 days later than "datetaken" column but only if "CourseTitle"column = CourseA?
Simulacrum
Windows XP Access 2003
datedue: Iif([Coursetitle] Like "CourseA",[datetaken]+365,"")
Competent Performer
Windows XP Access 2010 (version 14.0)
Thanks! As soon as I get a chance to throw it in there and verify, Ill set this to solved.
Competent Performer
Windows XP Access 2010 (version 14.0)
Hmmm, doesnt seem to be working. I understand now the concept of doing this....let me see if I can figure it out. But please feel free if you know why, let me know.
conditional formatting right(..)
Conditional Formatting
Posting Permissions
Reply With Quote