Update Query

[locksp]

I have two tables. One has been imported and contains 27 records. The data contained in some of the fields is identical. i.e. issue name and number.
I wish to update another table with the contents of the issue name and numberfrom this table. This I have managed OK. The problem is that I only need this information in the second table once and not for each of the 27 imported records.

Is there an easy way I can take the issue information from just one record and hold it in the second table?

 

[MSAccessRookie]

I have two tables. One has been imported and contains 27 records. The data contained in some of the fields is identical. i.e. issue name and number.
I wish to update another table with the contents of the issue name and numberfrom this table. This I have managed OK. The problem is that I only need this information in the second table once and not for each of the 27 imported records.

Is there an easy way I can take the issue information from just one record and hold it in the second table?

Take a look into the DISTINCTROW function of MS Access. If the Rows are Identical, then DISTINCTROW might eliminate your duplicates for you.

NOTE that I do not necessarily like to use this function, as can have side effects including the potential for slowing down speed when connecting to SQL Server and other non Access databases.

 

[vbaInet]

NOTE that I do not necessarily like to use this function, as can have side effects including the potential for slowing down speed when connecting to SQL Server and other non Access databases.

Quite weird isn't it. I bet it does some conversion to the SQL Server format whilst processing records.

But it's faster than DISTINCT in Jet.