Forum Discussion
Access back end with Visual Studio
I have written a query in MS access which is returning the data that I want. There are a numerous amount of IIF statements in the query but again, returning the data that I want. The problem is...
Maybe you can try this:
Iif( Left(p.parameter,2) = "u-", "Radionuclides", Iif( Instr(1,p.parameter."uranium")>0, "Radionuclides", km.description ) ) AS MethodGroup
Iif( Left(p.parameter,2) = "u-", "Radionuclides", Iif( Instr(1,p.parameter."uranium")>0, "Radionuclides", km.description ) ) AS MethodGroup