Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an inventory number field in a table. I want to select only those inventory numbers that are not duplicates. For example:
Inventory Number |
---|
111 |
112 |
112 |
113 |
115 |
115 |
115 |
Out of the values above I would want to select only 111 and 113. Is there an easy way to do this? Ideally I want a way to do this via a search in a list box containing this field.
Right click the listbox and select advanced search. Then enter the expression =count([Inventory Number])=1 and press the Go button:
Right click the listbox and select advanced search. Then enter the expression =count([Inventory Number])=1 and press the Go button:
Thanks!