Running sum over unbound textboxes

[apestaart]

In the detailsection of a report I calculate the values of anunbound textbox. (On Detail_format)
The unbound textbox is named : Tegoed.
I want to set the runningsum for this textbox via the properties of Tegoed. I choosed running sum over group. That does not work.
I tried to do it in an other way by defining in the "On open report Name" the code : reports!rptTegoed!Tegoed.runningSum = 1. Running this code gives me an error 2465 "Can't find the field 'Tegoed'"
What can I do to solve this problem?
Thanks in advance Apestaart

 

[apestaart]

Dear rjoubert,
[COLOR=red yellow]It works![/color]
To test I made a function with just one parameter and that worked. I tried to add the second parameter but that gave me the same Error as before.
I changed the "," into ";" between the to parameters and it works.
I changed the function NVakantiedagen in the same way and it works also. Is this normal?
Anyway this solved my problems and I thank you for your effort and patience.
best regards,
Apestaart

 

[rjoubert]

When you use the expression builder and double click on your function name, it initially shows up as...

= Nvakantieuren («sngUrencontract»; «sngSnipper»; «sngVakantie»; «sngTotaaluren»; «Geboortedatum»)

The «sngUrencontract» is a place holder for your 1st parameter. You have to replace all of the place holders with whatever you're passing into the function...either actual values or fields from your table/query/form.

 

[apestaart]

That is what I understood.
But, the point why it is working now is That I have changed the "," into ";" between the to parameters and ofcause I have gingen the placeholder the right parameters.
My final question is : I found examples of Dhookom where the parameters are sepetated by ",". In my case I have to use ";" is that normal? is that the right syntax?
apestaart
refer to thread 703-763824 31 jan 04 19:42

 

[rjoubert]

You should use the comma (",") to separate your parameters.

 

[apestaart]

It only works on my laptop with ";"
Is this a bug in the Dutch version of Access?
Apestaart