[AccessD] Update Query (I think) Question

Liz Doering ldoering at symphonyinfo.com
Wed Mar 29 21:21:58 CST 2006


Leave out the words 'field'


UPDATE 30_tbl_AI_Master2 SET 
[30_tbl_AI_Master2].ACCIDENT = "00-000"
WHERE  ((([30_tbl_AI_Master2].ACCIDENT)="00-00")); 


Liz 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, March 29, 2006 9:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Update Query (I think) Question

Susan,

Where did I mess up your genius?

UPDATE 30_tbl_AI_Master2 SET field
[30_tbl_AI_Master2].ACCIDENT = "00-000"
WHERE field ((([30_tbl_AI_Master2].ACCIDENT)="00-00"));

Joe Hecht
jmhecht at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, March 29, 2006 6:31 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Update Query (I think) Question

UPDATE table
SET field = "00-000"
WHERE field = "00-00"

Susan H. 

I have a field that currently is 00-00 format. I want to make it 00-000.

 

--
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