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 guess in Edit Query, make sure data type is text, then remove $$$$ using replace function and then change the data type back to number.