Re: Change value to an integer on a form

Tech-Archive recommends: Speed Up your PC by fixing your registry

Or perhaps reversing the functions. Since, I interpreted the posting as
saying the user wanted to round down the sum versus sum the rounded down
values.

Int(Sum([Field1]))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:%23dqYSdKVHHA.5100@xxxxxxxxxxxxxxxxxxxxxxx
Try a text box bound to:
=Sum(Int([Field1]))

Substitute your field name for Field1.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"crazyj0202" <u31880@uwe> wrote in message news:6e10bb5b0cac7@xxxxxx
I have a form that has detailed human resource info. I have a field that
is
in increments of .25. The sum can be x.00, x.25, x.50,and x.75. (x
bring
any number) Unless the increments =1 I do not want it to sum on a
particular
field on a report.

All I want is to always change the number to an integer (round down).
I.e,
if the sum on the report is 4.25, 4.50 or 4.75 I want another field to
take
that number and round down to 4. I hope this can be done.

I still want the 4.25 to show on the report, but just another box that
was
created just for the purpose of putting that number or whatever number
rounded down to the whole number.

(FYI the source of the textbox is =sum[sumofsar], I thought that if I put
dim
text86 as integer on form open and then I copied the same =sum[sumofsar],
into the source that it would work but it did not)

Thanks



.

Relevant Pages

  • Re: report counting option buttons
    ... > Then how do I get this query into the report? ... >>Duane Hookom ... >>MS Access MVP ... >>>>> sum field from first query. ...
    (microsoft.public.access.reports)
  • Re: iff statements
    ... MS Access MVP ... What I am trying to do is design a report that will be populated ... > sum values of data by month. ... > and there is no data to populate the field, the months do not show up on ...
    (microsoft.public.access.reports)
  • Re: Have Fields Automatically Calculate
    ... Yes, you can calculate the sum of the two numbers in a report, the same way you can on a form. ... Access MVP 2002-2005, 2007-2008 ... "John Spencer" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: Rounding Error Driving Me NUTS!
    ... I am familiar with the round the ... sum versus sum the round issue. ... The only difference between the reports that are consistent and the one that ... What leads you to say there's a rounding error? ...
    (microsoft.public.access.forms)
  • Re: Totalling within a report
    ... summary for THIS report, as 4311 means in-house projects, and other is simply ... > then query or create an expression for Sum the hours for whatever is ... > MS Access MVP ...
    (microsoft.public.access.reports)