[AccessD] Can't Alter Values in a Query with Subquery

I run into this occasionally as well.  Are there any calculated values in
either query?  That can cause this IIRC. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, February 28, 2007 10:48 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Can't Alter Values in a Query with Subquery

I've found that I can't alter values in a query with a subquery -- can't
alter any value in the query -- even values not evaluated in the subquery.
I'm sure there's a reason why, just curious -- never noticed this before. 

Susan H. 

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