Getting rid of "not assigned" in a field

[bowes884]

I want to filter out all of the "Not assigned" so that it only displays the numbers in the field.

 

[The_Doc_Man]

I infer that it is a text field. Otherwise you couldn't store "Not assigned" in it.

You can do this with a query. In the query grid, in one of the Criteria rows under the column that has this field, put in <> "Not assigned" - and then show everything else you wanted to show.