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 ‘