IIF statement in query 1

[blackcat9000]

Hi yer folks.

I have a form to showing a list of people who have paid membership fees for a year by having a value in the fees checkbox.

I am trying to provide a IIf statement or criteria to say if the year the fee was paid is not equal to the current year then change the fees checkbox value to false


IIf([feeyear]=Year(Now()),[Fees]=true,[fees]=false)

Can anyone help

Thanks in advance

 

[SteveR77]

It appears that you have the logic mixed up just a little.


IIF([feeyear]<>Year((Now()),[fees]=false,[fees]=true)


Hope this helps you,


Steve

 

[CajunCenturion]

You might try
[Fees]=IIf(([FeeYear]=Year(Now())),True,False)

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[saqibworld]

why are u not trying to use &quot;case when&quot; in your query

i think it will helps u

thanks

saqib ashraf

 

[Transcend]

Depends on what the database being used is doesn't it ?

If it's access i'm not sure that you can use 'case'.

Transcend

 

[johnwm]

Any reason why you don't do a simple update query?

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[blackcat9000]

Sorry for not replying sooner guys.

It seems I did have my logics a little mixed up after all.

Thanks for showing the error of my ways as it now works perfectly.

Thanks again for the help.

 

[SteveR77]

Transend,

FYI - Access does support Case logic through VBA.



Cheers,

Steve

 

[ESquared]

Why use Iif at all?

[Fees]=[FeeYear]=Year(Now())