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