Question Query Builder

hsalah

New member
Joined
Jun 27, 2011
Messages
2
Programming Experience
10+
I am just trying to build a query in a VB.Net dataset. I want to know the syntax for greater/less/equal operators within iif statement. For example, the SQL below will work in MS-Access, but, not, in VB.Net query builder.YearOfBirth: IIf([Year]>1945,'Working Age','Pensioner')How would you represent the above statement in VB.Net query builder? It is complaining about the ‘>’ operator, same with ‘
 
Thanks ss7thirty for your suggestion, however, I get this error 'IErrorInfo.GetDescription failed with E_FAIL(0x80004005)'. I tried to make the return the same type, i.e. integer, but still getting the same error!
 
Back
Top