Hi all,
I need to work out the formula to prevent duplicate values repeating in a multi-value field.
For example the field "Colours" may contain 5 rows of data. Let's say that for one record, the five values entered in the field are:
White
White
Red
Brown
White
...I need the report to only display:
White
Red
Brown
Can anyone assist?
many thanks
-Karen