trunc

From: Arul (Arul_at_discussions.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 14:00:13 -0700

I have a number 24.50. I'm trying to get the trunc of this value...no
rounding (24) via a query. I couldn't find an excel equivalent for "trunc"
in access. Anyone tell me what it is? thanks

Relevant Pages

  • RE: Touble With Dates
    ... But who would want to have a query only match a down-to-the-second ... If the intent of the query is to find all entries made anytime during ... TRUNC will trucate the value to the date only so ...
    (perl.dbi.users)
  • Help with Time being rounded off on timesheet
    ... places *AND* goto Tools>Options>Calculation>Precision As ... You can use the TRUNC() function to get the value returned ... >Column Worked Hrs should be 6.78 but it is rounding it to ... >help to keep the Column Worked Hrs from Rounding??? ...
    (microsoft.public.excel.worksheet.functions)