No! Not THOSE records !

[byterbit]

Why are other codes coming in ? I explicitly said "V44" !


The meter numbers are the same, but I just wanted to pull in those records in contacts where the code was V44; I'm getting many others as well.



docmd.runsql "insert into v select DISTINCTROW t.* from t inner join contacts on t.meter = contacts.meter where contacts.code ='V44' "

[ssanfu]

Without seeing some data, it is hard to say what the problem is. I sould start by creating a query using:

SELECT t.* FROM t INNER JOIN contacts ON t.meter = contacts.meter WHERE contacts.code ='V44'

If that doesn't give the desired results, I would try:

SELECT DISTINCT t.* FROM t INNER JOIN contacts ON t.meter = contacts.meter WHERE contacts.code ='V44'   "

Then try:

SELECT DISTINCTROW t.* FROM t INNER JOIN contacts ON t.meter = contacts.meter WHERE contacts.code ='V44'   "

When the query returns the desired recordset, copy the SQL and paste it into your Insert code.