I use CR9 to pull reports from our software system, Macola.  One table I use is automatically cleared after orders are invoiced and then filled during the day when orders are entered.

Somehow there is data in the field for the ship_to_name and ship_to_address that should not be there (I use browse field data to review) and is pulling erroneous info into the report.

Does anyone know how I can delete from table?  Those fields are the only ones that have it. 

This has not happened before today and because I am trying to have our office move away from spreadsheets and utilize our system, I am loosing credability since the report is coming up wrong today.

Help anyone?

Jeanette