Running fraction penny rounding

[hardy1976]

Hi,

For one reason or another... I need to move something from Excel into Access and there is one formula that I need to replicate that I cant do!!!!

=INT(SUM(A$2:A2)*100)/100-ROUND(SUM(B$1:B1),2)
The formula is the then copied down.


basically it is used to do running roundings... so everyone with a faction of a penny is rounded and then once you get to a penny that person gets it!!!


running individual
£0.00054
£0.00108 £0.00054
£0.00162 £0.00054
£0.00216 £0.00054
£0.00324 £0.00108
£0.00432 £0.00108
£0.00540 £0.00108
£0.00648 £0.00108
£0.00756 £0.00108
£0.00864 £0.00108
£0.01026 £0.00162 Penny for this one
£0.01188 £0.00162
£0.01350 £0.00162
£0.01512 £0.00162
£0.01728 £0.00216
£0.01944 £0.00216
£0.02160 £0.00216 Penny for this one
£0.02376 £0.00216
£0.02592 £0.00216
£0.02808 £0.00216
£0.03078 £0.00270 Penny for this one
£0.03348 £0.00270
£0.03618 £0.00270
£0.03888 £0.00270
£0.04158 £0.00270 Penny for this one
£0.04428 £0.00270
£0.04752 £0.00324
£0.05076 £0.00324 Penny for this one
£0.05400 £0.00324
£0.05724 £0.00324
£0.06048 £0.00324 Penny for this one

 

[gemma-the-husky]

the reason its hard is because in excel, you have a previous row to work from

in access you dont really have a concept of a previous row.

 

[hardy1976]

the reason its hard is because in excel, you have a previous row to work from

in access you dont really have a concept of a previous row.

So store them in a varible and have a if > than 1 type statement? Any other way?