Forum Discussion

unclejemima's avatar
unclejemima
Post Patron
8 years ago
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...
Need Help
  • Sandeep641's avatar
    Sandeep641
    8 years ago

    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.

Sandeep641's avatar
Sandeep641
Frequent Visitor
8 years ago

go to edit queries, right click account column replace errors with null or what ever u want

unclejemima's avatar
unclejemima
Post Patron
8 years ago

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!!

  • Sandeep641's avatar
    Sandeep641
    Frequent Visitor
    8 years ago

    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.