[AccessD] Delete Query Problem

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon Aug 13 10:18:08 CDT 2007


The following delete query asks specify the table you wish to delete
records from. It looks the same to me as other delete queries I have
created. Unique records is set to yes.

 

DELETE [tbl Scaleup Forecast SU 8-08-2007].PID, [tbl Scaleup Forecast SU
8-08-2007].YearMth, [tbl Scale up Forecast SU 8-08-2007].[ForCO2Inj
(HCPV/Yr)], [tbl Scaleup Forecast SU 8-08-2007].[ForWatInj (HCPV/Yr)],
[tbl Scaleup Forecast SU 8-08-2007].CO2Days, [tbl Scaleup Forecast SU
8-08-2007].WatDays, [tbl Scaleup Forecast SU 8-08-2007].BOPD, [tbl
Scaleup Forecast SU 8-08-2007].MCFCO2PD, [tbl Scaleup Forecast SU
8-08-2007].BWPD, [tbl Scaleup Forecast SU 8-08-2007].MCFHCPD, [tbl
Scaleup Forecast SU 8-08-2007].BNGLPD, [tbl Scaleup Forecast SU
8-08-2007].MCFIPD, [tbl Scaleup Forecast SU 8-08-2007].BWIPD, [tbl
Scaleup Forecast SU 8-08-2007].AcvtdWELL, [tbl Scaleup Forecast SU
8-08-2007].AcvtdPATT, [tbl Scaleup Forecast SU 8-08-2007].ActWELL, [tbl
Scaleup Forecast SU 8-08-2007].ActPATT

FROM [tbl Scaleup Forecast SU 8-08-2007] INNER JOIN [tbl Scaleup
Recompletions] ON ([tbl Scaleup Forecast SU 8-08-2007].YearMth = [tbl
Scaleup Recompletions].YearMth) AND ([tbl Scaleup Forecast SU
8-08-2007].PID = [tbl Scaleup Recompletions].SubPID)

WHERE ((([tbl Scaleup Forecast SU 8-08-2007].PID)=[tbl Scaleup
Recompletions]![SubPID]) AND (([tbl Scaleup Forecast SU
8-08-2007].YearMth)=[tbl Scaleup Recompletions]![YearMth]));

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 




More information about the AccessD mailing list