Skip to Content

Serial Number Query

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]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded