none
Function FLOOR doesnt' work in SQL SELECT using Microsoft.Jet.OLEDB.4.0 RRS feed

  • Question

  • Hello everybody,

    I Have a little problem.

    I'm connected to a Access Db with provider Microsoft.Jet.OLEDB.4.0.

    I want to take the integer part of a numeric field to determinate in which interval belongs. The interval's length in the example is 100.

    I've written:

     

    SELECT  Field1, FLOOR (field1/100) AS Interval

    FROM Table1

     

    I receive this error:

    SQL's Executing error

    Error Source: Microsoft JET Database Engine

    FLOOR is not a definited function

     

    Probably, if i'd used Microsoft SQL Server I wouldn't have this problem. However...

     

    Thank in advance

    Mauro

     

     

     

     

     

     

    Monday, June 25, 2007 11:02 AM

Answers

All replies