Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Queries
Iif Query
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Jerry Whittle, post: 13434989"] Is [1/1/2009] a field name? If not, it will not work. Try #1/1/2009# for a January 1st, 2009 date. Your DateDiffs don't have an interval specified. Probably need something like this: DateDiff("yyyy", [Regeneration Data Date] , #1/1/2009#) Next is your logic. Assuming that Regeneration Data Date is today, DateDiff would produce a 0. 0 is less than 1, 3, 5, and 10. An IIf statement would try to evaluated all of them as True. You need some Betweens in there. Also you have < 10 and > 10. If the number is exactly 10, there will be a problem. There could also be problems if a null value gets in there. [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Queries
Iif Query
Top
