Help needed in Iff Statement for Access!

**warehouse peon** · 12-02-2010

Hi friends,
I have done some basic things in Access, but I am not having enough knowledge about it. I have created a database which is having the records being used by the Date Completed. In this I am storing the Date at which the task is completed. I have written a command that can retrieve the months from my field date. I am doing that because I want to show the first 3 months or last 3 months. I have used the Iff Statement in Access for the same purpose.!! Hoping for help faster..!!

**Allan.d** · 12-02-2010

It would be better to me (and others) if you provide the command that you are using.!! Because no one can come to know exact what is causing the issue.!! I think that you should have information about the IIf statement. You can use IIf anywhere you can use expressions. You use IIf to determine if another expression is true or false. So this can be useful for checking the condition. If the expression is true, IIf returns one value; if it is false, IIf returns another. I am giving the syntax for the same :

Code:

IIf(expr, truepart, falsepart)

**warehouse peon** · 12-02-2010

Thanks for replying me..!! Here is the sample of my query which I was talking about :

Code:

Date: IIf([Month]="January" And " February" And "March" And "April" And "May" And "June",
"First 3 Months","Last 3 Months")

I have also tried 'or' instead of 'and', but still no success.!! Help me.

**Reegan** · 12-02-2010

I think that you must use "OR", since the month cannot take the different values at the same time. I think that you must try to give the numbers instead of names to months. If you do that, then your query should be like this :

Code:

Date: iif(Month < 4 ,"First 3 Months","Last 3 Months")

Hope that this helps.!!

**MELTRONICS** · 12-02-2010

I think that using the above solution provided by the 'Reegan' for your problem would be better. You should also know that when your data can hold multiple years, you must append the year. If you don't do this then calculated values will be wrong. I think that same thing is happening in your case. Hope that this can solve your issue.