[AccessD] Update query quit working

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Nov 8 10:34:45 CST 2005


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.

 




More information about the AccessD mailing list