I have a form that uses has a series of about 10 different queries to
get the final VIEW query to populate my form. I wrote the below to find
the duplicates, which works. I don't want to delete the duplicates just
not show them. Any ideas? I just want to show the records that have NO
duplicates.

By it cannot identify each row uniquely, since it is the field you're using
to detect duplication.

If you want to be able to present just one row out of a group of duplicates,
you must have one (or some combination of fields) that would uniquely
identify the rows, so that it is possible to select the
min/max/first/last/something unique identifier from within the group
identified by the same UWID. Sometimes a date field works for this. If you
have a DateCreated field, or DateUpdated, that might do the trick.

By it cannot identify each row uniquely, since it is the field you're using to detect duplication.

If you want to be able to present just one row out of a group of duplicates, you must have one (or some combination of fields) that would uniquely identify the rows, so that it is possible to select the min/max/first/last/something unique identifier from within the group identified by the same UWID. Sometimes a date field works for this. If you have a DateCreated field, or DateUpdated, that might do the trick.