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

    If the result of a subquery is not required to be displayed, but merely to be used for setting up a criteria, the query remains updateable. 

    On the other hand, if the subquery result has to represent a displayed column, the query becomes non-updateable.

    Following alternative remedial measures can be considered so as to ensure that the main query remains updateable:
    (a) Adoption of user defined functions in lieu of subquery.
    (b) Adoption of domain aggregate functions in lieu of subquery.

    It is also observed that calculated fields based upon subqueries can lead to problems if used for grouping levels in a report. That problem also stands addressed by the remedial measures suggested above.

A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Susan Harkins 
  To: 'Access Developers discussion and problem solving' 
  Sent: Wednesday, February 28, 2007 22:11
  Subject: Re: [AccessD] Can't Alter Values in a Query with Subquery


  Yelp... calculated field. You know, I've written about this at least three
  times, and I can't even remember it myself. :( 

  Interestingly, a query based on the non-updateable query is also
  non-updateable. Don't really know a way around that. What do you guys do? 

  Susan H.