[AccessD] Query gives duplicate records

Hi Chester

Try with a dot:

  [tbl Wells on SCADA].[Wellname]

/gustav

>>> Chester_Kaup at kindermorgan.com 17-07-2008 23:07 >>>
This query asks for a value for [tbl Wells on SCADA]![Wellname].

INSERT INTO [tbl Wells on SCADA] ( Wellname )
SELECT DISTINCT [qry Water Injectors on SCADA].Wellname
FROM [qry Water Injectors on SCADA]
WHERE ((([qry Water Injectors on SCADA].Wellname)<>[tbl Wells on SCADA]![Wellname]));

If I modify the query like this I don't get asked for [tbl Wells on SCADA]![Wellname] but I get duplicate records.


INSERT INTO [tbl Wells on SCADA] ( Wellname )

SELECT DISTINCT [qry Water Injectors on SCADA].Wellname

FROM [qry Water Injectors on SCADA], [tbl Wells on SCADA]

WHERE ((([qry Water Injectors on SCADA].Wellname)<>[tbl Wells on SCADA]![Wellname]));

What am I doing wrong here. Thanks.



Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799