Skip to Content

Serial Number Query

Nov 24, 2016 at 08:22 AM


avatar image

Hi all

Please advise how to correct this Query as the Serial Number is showing

e.g key in serial number 96E156 but on the excel report 9.6E+157

SELECT T0."customer", T0."custmrName", T0."internalSN", T0."manufSN", T0."itemCode", T0."itemName", T0."status", T0."county" AS "WARRANTY START DATE", T0."instLction" FROM OINS T0 WHERE T0."customer" >=[%0] AND T0."customer" <=[%1]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Johan Hakkesteegt Nov 24, 2016 at 09:56 AM

Hi Kedalene,

There is nothing wrong with your query. The problem is with Excel.

When you export the report to Excel, please go about it as follows:

  1. Save as text file and note to what folder you save it.
  2. Close the Excel sheet that B1 opened automatically
  3. Open Excel again if necessary
  4. From within Excel, open the text file you saved in step 1 (you will have to change the file type from Excel to text files in the open file dialog)
  5. Excel will open an import wizard.
  6. In the import wizard, click next twice.
  7. On the third screen of the import wizard, select the column that holds the serial numbers, and change it to type text.
  8. Click finish on the import wizard



10 |10000 characters needed characters left characters exceeded