How to Extract One Copy of Each Code from a Table Column?

[David Godinger]

Hi,

In a table I have a column of codes, such as "abc," "ry," and "wdrwef."
Each code is listed one or many times in the column.

How can I generate a new table with a column that automatically keeps track
of the codes and generates just one occurance of each code? It would help
if the table could automatically keep the list up to date. (Am I barking up
the wrong tree? Should I instead be thinking of queries or macros?)

(After I get the above done, my next step is to figure out how to put the
list in a code-combo box.)

Thanks for all the great help that I've been getting.

Best,

Dave

 

[Van T. Dinh]

Query is the go.

Check JET SQL Reference is Access Help for the reserved word "DISTINCT".

--
HTH
Van T. Dinh
MVP (Access)

Hi,

In a table I have a column of codes, such as "abc," "ry," and "wdrwef."
Each code is listed one or many times in the column.

How can I generate a new table with a column that automatically keeps track
of the codes and generates just one occurance of each code? It would help
if the table could automatically keep the list up to date. (Am I barking up
the wrong tree? Should I instead be thinking of queries or macros?)

(After I get the above done, my next step is to figure out how to put the
list in a code-combo box.)

Thanks for all the great help that I've been getting.

Best,

Dave

Martin King