[AccessD] Update query quit working

Hmmmm....returned the right date, then?

Have any of the properties on the target field been changed?

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 9:11 AM
Subject: Re: [AccessD] Update query quit working


> You mean something like this:
>
> SELECT DISTINCT WellMonthlyVol.Date
> FROM WellMonthlyVol
> WHERE (((WellMonthlyVol.Date)=DMax("[Date]","WellMonthlyVol")));
>
> This works correctly.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> - Beach Access Software
> Sent: Tuesday, November 08, 2005 11:01 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Update query quit working
>
> 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
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>