formula for a view
Posted on 2004-04-07
I've a form named "Cus" in which one of the field has the following properties.
fieldname = MTNO
Type = text,
allow multiple values is checked.
in some of the forms this field has duplicate values in it.
I want to create a view which will show only records which has duplicate values in this field.
Please advise on what would the SELECT statement be in the view.