Extract one column into new table

Anonymous Well, there are ways but none of them are exactly pretty in my opinion. My first question would be why you feel you need to append versus just refresh the entire list each time. Are you concerned about performance or are you concerned that some values may "go away" later?

You can do an Append query, but, again, it isn't exactly pretty in my opinion. You would need to have a date column or something that you can key off of like an Index perhaps as being "current". You would construct your query as before using Reference. You would then filter for all dates up to a certain date or an Index up to a certain index. Then remove other columns. Now, you would construct a second query the same way, using Reference but this time enact the opposite filter, greater than a certain date or index. Remove other columns on this one as well. You would then create an Append query or otherwise append your queries together. You could then use a "remove duplicates" operation to get rid of any duplictaes if you care about that.

Not exactly a work of art but doable.