Susan Harkins
harkinsss at bellsouth.net
Thu Dec 1 10:09:32 CST 2005
Why do you list * and PID? Wouldn't * include PID? DELETE FROM table WHERE You don't even need the table.* -- DELETE's going to delete all the fields for the appropriate record. Susan H. Here is the delete query. Get a message of cannot delete from specified table. Why? DELETE Constants.*, Constants.PID FROM Constants WHERE (((Constants.PID)=[CONSTY]![PID])); 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.10/189 - Release Date: 11/30/2005