Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

to edit data in a select query (more then 1 table referenced)

Discussion in 'Information Technology' started by Robert B, Jul 28, 2006.

  1. Robert B

    Robert B
    Expand Collapse
    Guest

    My task is simple. I have a query that refernces several tables. The result
    is exactly what I need to edit. However I am unable to change any of the
    table values in the query.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Indo-Canadian Sikh Student Selected For Arctic Expedition - Chandigarh Tribune Breaking News Jul 8, 2016
    Sikhi Meditation As A Way Of Life In Sikhism Sikh Sikhi Sikhism Jun 11, 2016
    How To Meditate? | How To Do Naam Simran? | As Per Gurbani? Gurmat Vichaar Jun 1, 2016
    How To Meditate (dhyaan / Simran) ? Am I Doing It All Wrong. I Can't Concentrate And Feel Sleepy Intellectual Articles Mar 25, 2016
    Sikh News Daily Meditation: Clear Mind Breaking News Mar 11, 2016

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Generally only 1 table can be edited at a time, but you can include data
    from other tables in that query. Queries must be updateable. Go into the SQL
    view and try changing the select statement from:

    Select ...

    to:

    Select Distinctrow ...
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Robert B" <Robert B@discussions.microsoft.com> wrote in message
    news:49CC21E6-E251-48C5-894B-408509B959A4@microsoft.com...
    > My task is simple. I have a query that refernces several tables. The

    result
    > is exactly what I need to edit. However I am unable to change any of the
    > table values in the query.
     

Share This Page