[AccessD] Update query quit working

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Nov 8 12:39:33 CST 2005


You are correct that [Date] is a reserved word. Sometimes we are stuck
with apps built on top of access that don't use real good field names.
Anyway tried changing it to [RecordDate] still no records are updated. I
am puzzled.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson,
Karen
Sent: Tuesday, November 08, 2005 11:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Update query quit working

Isn't [Date] as reserved word? 


Karen S. Nicholson
Programmer Analyst
EG&G Technical Services, Inc.
Pittsburgh, PA
Phone: 412-386-6649
Email: cyx5 at cdc.gov


-----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 12:01 PM
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






More information about the AccessD mailing list