cumulative values

[mjd3000]

Hi,

I have a cumulative field in my report, and I want to access the last value in my cumulative field. For example :

Person CumulTarget
1 5
2 9
3 13
4 20

How do I reference the last cumulative figure i.e. 20 in this case?

 

[RiverGuy]

Reference it where? In a single textbox? In a group header/footer? In the details of your report?

 

[mjd3000]

I want to use it in a textbox for a calculation.

 

[xlbo]

Is CumulTarget calculated or does it come out like that from the dataset?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[mjd3000]

Hi,

Figured this out...I just needed to reference the dataset.