Help writing IIf Statement in Query

[tyjan10]

Hello all. I need help writing a IIf Statement.

- My Fields are Name, Event, Start Date, and End Date.

- When I do a Query if the Start Date is <Date()-365 I would like the Start Date to change to Date()-365, if it does not meet that criteria I would like for the Start Date to stay the same.

- I need the same thing for the End Date Field. IIf the End Date is >Date()+365 I want the query to return with Date()+365 or else stay the same.

I am new to MS Access any assistance will help..Thanks in advance

 

[jdraw]

In plain English What are you trying to do? There may be a better way.
see
http://www.techonthenet.com/access/functions/advanced/iif.php