create an array using various field values
could do with a quick pointer in the right direction.
I've got 30 currency fields held at the detail level of a report. I'm trying to pull out only those values that have a value. I thought the best way would be to use an array......
So, I need to pull out Field3: £10.00; Field4: £2.00; Field6: £1.00...both the field value and its position in the array.