_giles_ Posted May 30, 2012 Share Posted May 30, 2012 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 Link to comment Share on other sites More sharing options...
eos Posted May 30, 2012 Share Posted May 30, 2012 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. Link to comment Share on other sites More sharing options...
_giles_ Posted May 31, 2012 Author Share Posted May 31, 2012 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? Link to comment Share on other sites More sharing options...
comment Posted May 31, 2012 Share Posted May 31, 2012 (edited) 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, 2012 by comment Link to comment Share on other sites More sharing options...
Vaughan Posted May 31, 2012 Share Posted May 31, 2012 A value list cannot be based on an unstored (unindexed) field. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4361 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now