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 that when I try to use the data in Visual Studio. Using Closed XML I am trying to output this query to Excel using code.
The returns on IIFs are not the same.
For instance:
Iif( p.parameter LIKE "u-*", "Radionuclides", Iif( p.parameter LIKE "*uranium*", "Radionuclides", km.description ) ) ) AS MethodGroup
In the query when I look at it with Access, I am seeing the radionuclides methodgroup. BUT, when I run the query through Visual Studio and output it to Excel, there is no radionuclides methodgroup.
It's like the IIF is not working.
I am not even sure what to Google to begin to research this problem.
