[AccessD] Update query broke

The brackets need to be there in order to tell Access that the object is a
field in the query.  If I remove the brackets, Access places quotes around
it and try to update the field with the word "Address" (not good).

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris
Manning
Sent: Thursday, October 27, 2005 2:23 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Update query broke


The brackets around Address are the problem.  They make Access think this is
an internal parameter.  Try it without them.

Doris Manning
mikedorism at verizon.net


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com