building an array from a table

[Guest]

I'm storing invoice entries in a table. Since that table contains mulitle
entries with the same invoice number, I wish to build a separate table with
just one copy of the invoice number stored. I envision reading each record
in the master invoice table, keeping only the first instance of each invoice
number and then storing those numbers in another table for easy lookup
features for review. I think populating an array with those numbers, then
transfering the array contents to a new table is the way to go. I have
several books with lots of code examples, but I seem to missing one or two
important steps that the authors are assuming I should know and don't
mention. Any help with this would be appreciated as I wish to get this
project finished and on to the customer. The only formal training I have is
as a COBOL programmer and self-teaching Access. It is a daunting task for
sure.

 

[Rick Brandt]

I'm storing invoice entries in a table. Since that table contains
mulitle entries with the same invoice number, I wish to build a
separate table with just one copy of the invoice number stored. I
envision reading each record in the master invoice table, keeping
only the first instance of each invoice number and then storing those
numbers in another table for easy lookup features for review. I
think populating an array with those numbers, then transfering the
array contents to a new table is the way to go. I have several books
with lots of code examples, but I seem to missing one or two
important steps that the authors are assuming I should know and don't
mention. Any help with this would be appreciated as I wish to get
this project finished and on to the customer. The only formal
training I have is as a COBOL programmer and self-teaching Access.
It is a daunting task for sure.

All you need is a query...

SELECT DISTINCT InvoiceNumber FROM TableName

 

[Guest]

Thanks. I knew I was making it more difficult than it had to be. Will try
it and see what happens. Thanks again.