Hi. I'm having a hard time to figure out what's not working.
I need to have some "case... when" statement in a query to import data from an access Database to an Excel spreadsheet.
I tried with a IIF statement and it worked great within Access.
But the problem is that to import date into Excel, you need to use MsQuery and not Access. In MSQuery, the IIF function does not work.
Can somebody have a clue about this problem, of a way to go around it?
thank you.
I need to have some "case... when" statement in a query to import data from an access Database to an Excel spreadsheet.
I tried with a IIF statement and it worked great within Access.
But the problem is that to import date into Excel, you need to use MsQuery and not Access. In MSQuery, the IIF function does not work.
Can somebody have a clue about this problem, of a way to go around it?
thank you.
