But you can apparently use an Excel function if you have a reference to Excel. To use it in a query, wrap the worksheet function in an Access UDF
Code:
Public Function fCeiling(vDblValue As Var, vSignificance As Var) As Double
fCeiling = Excel.WorksheetFunction(vDblValue, vSignificance)
End Function
I wish I could say I thought of it myself...
https://access-programmers.co.uk/for...d.php?t=159228
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.