Forum Discussion
Solved
Modify Query to ignore $$$$
I get a error in a query from a table called Trandata with the column called Account. Every once in a while the Point of Sale system will throw in a $$$$ instead of a numberical value (typically 4 d...
you have to type "null" after choosing replace errors, it should work irrespective of the column type
It will automatically replace all values to null eveytime you refresh, it would remember.
I tried to set to null, () and blank...but it would not accept those values (it a whole number column)
Best I could do is 0. Is there any special way to force them to null or blank instead of zero?
Also, do I have to do this each time I refresh my dataset...or will it remember my selection to replace errors with whatever for that column.
Thanks!!
you have to type "null" after choosing replace errors, it should work irrespective of the column type
It will automatically replace all values to null eveytime you refresh, it would remember.