Access 2013 desktop database Windows 7
I have two tables which are identical in structure (just field1 and field2, both simple numerics)
I need to copy the rows from table 1 which has a unique value of field1 ( just use the first row of duplicate values of field1)
I should be able to do this in one command something like :
Insert * into Table 2 from (Select DISTINCT * from Table1) ;
Can't get it quite to work. How do I specify I only want the distinct part to be against field1.
I've gotten this to work using VBA and scanning a recordset doing selected insert commands but it's very slow for 15,000 records
Once again, your help is most appreciated.