Hi all,
I have been having issues with importing data into excel I get the message Data could not be retrieve from database. I thought it was an excel issue but I did a few things.
Since my query had some expressions in it I made a query of that query just to see if that worked, it didn't so then I started removing columns from the query and bingo issue gone. I then went back to the original query with the expressions in it and hid the last column and bingo that worked. Thing is I can not for the life of me figure out why this would be the case.
I have made sure there is no errors in it with a iff expression so if there is a non value it returns a 0.
The field is not formatted to any thing same as the others.
So what the Hell could it be?
I have been having issues with importing data into excel I get the message Data could not be retrieve from database. I thought it was an excel issue but I did a few things.
Since my query had some expressions in it I made a query of that query just to see if that worked, it didn't so then I started removing columns from the query and bingo issue gone. I then went back to the original query with the expressions in it and hid the last column and bingo that worked. Thing is I can not for the life of me figure out why this would be the case.
I have made sure there is no errors in it with a iff expression so if there is a non value it returns a 0.
The field is not formatted to any thing same as the others.
So what the Hell could it be?