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!
Search results for query: *
- Users: wildcherry98
- Order by date
-
IIF Expressions in Query
Okay one more question... (sorry just so happy that someone could FINALLY help with the last question...) how do i encorporate Forecolor now?? would it be as simple as Iif([Last Review Date]>=#11/1/2006# And ([LastReviewDate]<=#10/31/2007#,"Complete",THEN forecolor=vbgreen?? or am i missing...- wildcherry98
- Post #10
- Forum: Microsoft: Access Queries and JET SQL
-
IIF Expressions in Query
PHV YOU ARE A GOD!!! Thank you so much, i have been struggling with this for about 2 weeks straight... i bow down to you!!! [afro]- wildcherry98
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
IIF Expressions in Query
Greg Thanks for the quick response-- i have the extra paren there where you highlighted and i am still getting the following error when i attempt to close: Status:Iif([Last Review Date]>=#11/1/2006# And ([LastReviewDate]<=#10/31/2007#,"Complete", IIf([Next Discussion...- wildcherry98
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
IIF Expressions in Query
Okay Here goes.. I have a complicated question here. I am currently building a db for career development in my workplace. The main fields that i am having some issues with is the following. I have three fields labelled as the following: 1) Last Review date 2) Next review date ( i have this...- wildcherry98
- Thread
- Replies: 10
- Forum: Microsoft: Access Queries and JET SQL
