Skip to Content
0
Feb 16, 2011 at 04:26 AM

How to suppress repeated values in rows of a table field

143 Views

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