|Subject:||Need help with Excel Microsoft Query|
|Posted by:||erick-flores (erickjflor…@gmail.com)|
|Date:||Wed, 29 Aug 2007|
I want to add a field to my query based on another field. The "another
field" is a date field (field_date).
What I want to do is: IF(field_date >=01/01/00 and <=12/31/00, "2000",
I want to get the year by itself based on the field_date, perhaps
there are another ways of doing this?
But obviously i am missing something or doing something wrong, because
when I tried to run the query i get the Sysntax error.
Thanks in advance