Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Nov 8 11:00:58 CST 2005
Try it as a select query to see if the right MAX date is coming across? Rocky ----- Original Message ----- From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, November 08, 2005 8:34 AM Subject: [AccessD] Update query quit working >I have the following update query in a database. It used to work. > > > > UPDATE MAX_PROD_DATE SET MAX_PROD_DATE.MAX_DATE = > DMax("[Date]","WellMonthlyVol"); > > > > I ran a select query to get the max date from the table WellMonthlyVol > and it worked fine returning the correct value. > > > > What am I missing that it no longer works? No records are updated. > Thanks. > > > > > > > > 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 >