Appending data and losing values in a filter

D

Donna

I have a table that I want to append data to. The table filters by form and
shows the unique values in each column correctly.

As soon as I append data using the Append Query option to this table, the
unique values no longer show when I filter by form. There is only Null, IS
NOT NULL as options.

How can I append or copy/paste the data without losing the filter by form
values?
 
Top