capdownlondon
Registered User.
- Local time
- Today, 14:02
- Joined
- Mar 18, 2007
- Messages
- 52
I know the theory behind what i want to do, but need some help programming this into my report.
I have a field that displays a running sum (over group), but what i want is either this same field or a 2nd field to display that same information but i want it to run through a module that does something like this (using textbox1 as the one with the running sum):
x= textbox1 / 350
-now just get the numbers after the decimal point and muliply by 350
and put this in textbox 2
Basically the effect of this will display the value upto 350 in a loop. so when it hits 350 the next number is then 1.
So 351 in textbox 1 will return 1 or 702 will display 2
I have a field that displays a running sum (over group), but what i want is either this same field or a 2nd field to display that same information but i want it to run through a module that does something like this (using textbox1 as the one with the running sum):
x= textbox1 / 350
-now just get the numbers after the decimal point and muliply by 350
and put this in textbox 2
Basically the effect of this will display the value upto 350 in a loop. so when it hits 350 the next number is then 1.
So 351 in textbox 1 will return 1 or 702 will display 2
