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

  • Thread starter Thread starter David Godinger
  • Start date Start date
D

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
 
Query is the go.

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

--
HTH
Van T. Dinh
MVP (Access)


David Godinger said:
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
Click to expand...
Martin King
 
Back
Top