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

 

[dk_hanal]

Here's the Excel formula that I would like to convert into Access Query Syntax. Anyone?
=value(year(e2) + if(f2< date(1990,1,1), 60,62))

 

[Joe4]

Try this:

MyCalc: year([e2]) + iif([f2] < DateSerial(1990,1,1),60,62)

<dateserial(1990,1,1),60,62)[ code]<="" html=""></dateserial(1990,1,1),60,62)[>

 

[Norie]

Perhaps something like this,

Year([Field1]) + Iif([Field2]< DateSerial(1990,1,1), 60,62)

where Field1 and Field2 represent E2 and F2 respectively.

 

[MARK858]

Just to point out if you want the less than symbol to appear without the spaces you can use & lt; (without the space) in place of < to display correctly.

It is only as far as I know the < symbol followed by a letter that causes the issue.

Just another option.

 

[dk_hanal]

Thank you very much. It worked perfectly. @mark858, Noted for the future.

 

[james_lankford]

or from now on just post the formula in pastebin.com and then post a link

 

[MARK858]

or from now on just post the formula in pastebin.com and then post a link

The trouble with links is they can/do get removed at later dates which doesn't help anyone looking at the thread in future when searching for help.

 

[xenou]

It is also possible to post your formula using the php code tags.

=(A1>0 and A1<1)