[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