[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