Convert Excel Formula to MS Access Query Syntax

[dk_hanal]

I need to convert this excel formula to access query syntax: =VALUE(YEAR(E2) + IF(F2<DATE(1990,1,1), 60, 62)) - while E2 and F2 being Access Field names. Any help is much appreciated.

Thank you.

dk_hanal

 

[Rorylfc]

You seem to be missing the full formula...

 

[dk_hanal]

My Apologies - the full formula is =VALUE(YEAR(E2) + IF(F2<DATE(1990,1,1), 60, 62))

 

[dk_hanal]

=value(year(e2) + if(f2<date(1990,1,1), 60, 62))

 

[Rorylfc]

Try posting your formula between code tags

  [/code  !!Just put a square bracket at the end of the last Code to make it work

[code] Like this

 

[dk_hanal]

something seems to be not working, it truncates the formula I post

 

[dk_hanal]

  =value(year(e2) + if(f2<date(1990,1,1), 60,="" 62))="" <="" span="">

</date(1990,1,1),>

 

[dk_hanal]

tried with the

- still doesnt' work!

 

[Joe4]

See here: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

 

[dreid1011]

=VALUE(YEAR(E2) + IF(F2 < date(1990,1,1), is="" span="" < ="" appreciated.="" much="" help="" Any="" names.="" Field="" Access="" being="" F2="" and="" E2="" while="" -="" 62))="" 60,="" > : )

Mind the extra spaces I put around the < > and at the end to avoid the smiley face : ).