Sum of fields with "INT" function

[scallebe]

Good morning everybody,

I have in my report some calculated fields and I want to calculate the sum of these fields in my pagefooter.

From the calulated fields I need the integer part of the result.

The formule for I use is e.g. Fieldname : "Fifty" =Int([payOut]/50) and it works fine.

e.g. 2320/50 = 26,4 --> integer part = 26

Now I want to make the sum of these fields in my page footer and it doesn't work… :banghead:

I use the formula : =Sum([Fifty])

When running the report Access asks me a parameter value "Fifty"

Can someone help me please…

Thanks

Greetz

Pascal

 

[isladogs]

Try

=Sum(Int([payOut]/50))

Or if you want to round the values after summing, use

= Int(Sum([payOut]/50))

Hope that helps

 

[arnelgp]

you can also use query as recordsource of your report:

select payout, 
    [payout]\50 as Fifty, 
    (select sum([payout]\50) from yourTable) As Expr1
from yourTable group by payout;

all you need to do is set the ControlSource of your textbox in page footer to Expr1.

 

[CJ_London]

have you tried allen browne's technique for summing in page footers?

http://allenbrowne.com/ser-11.html

 

[scallebe]

Thank you all for reply.

I tested all your solutions…

#Pat Hartman,

That was something I didn't know, It explanes a lot in my other DB's …

See you all next time.

Greetz

Pascal

 

[CJ_London]

I tested all your solutions…

to help others who might find this thread when having a similar problem - it would be helpful for them to know which of the solutions you tried worked for you - or perhaps none of the worked?

 

[scallebe]

ok, sorry about that...

The 2 formula's of Isladogs worked fine...

Working with a query was also a good method #arnelgp

And AllanBrown's solutions : Works fine too… #CJ LONDON


Thanks a lot...

Greetz

Pascal