Dear All,

I have a field [values] where a range of values (say A - E) can be added. Viewed across a number of records we get something like

Record 1 [values] A

Record 2 [values]

Record 3 [values] A

Record 4 [values] C

Record 5 [values] B

Is there a way of producing a summary field of [values] where the above would return :

A

B

C

thank you

Create a value list based on your field, then use ValueListItems ( Get ( FileName ) ; "yourValueListName" ).

Don't forget to put the name of the value list in quotes.

Thanks, I've done this and it appears to work most of the time. But the field appears to fail to update at times (I now this shouldn't be the case) is there anything that could be causing this?

1. Make sure the calculation field is unstored.

2. Keep in mind that - unlike a summary field - a value list includes all values in the field, not just those in the current found set.

Edited May 31, 201213 yr by comment

A value list cannot be based on an unstored (unindexed) field.