[AccessD] update query using values from a query

Jim Lawrence (AccessD) accessd at shaw.ca
Wed Jun 2 20:03:36 CDT 2004


Sorry Susan:

Was rushing and did not read the whole paragraph.....

Well I would have helped :-)
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Wednesday, June 02, 2004 5:16 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] update query using values from a query


??? Jim -- I don't understand the request. 

Susan H. 

Hi Susan:

Show me the query...

Jim



I am trying to do an update query updating a table with the values from a
query. I get the message that "Operation must use an updateable query"  so
it won't run. But I am not trying to update the query! I'm just wanting to
use the values from the query to update the table.

==========That error means you can't use the query to update the underlying
table. Not every query is "updateable." There are rules and I'll send you
something privately. 

Susan H. 

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