Results 1 to 5 of 5
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    How to Edit in a Query

    I have a bunch of Data in a Checkbook register frm/tbl etc. And I realized I have incorrectly attributed some of the transactions to the wrong account.

    If i make the changes in the form that I have created it will take forever (sort to transaction account type, select record, select edit record, which I have set up stupidly and it closes the main form to open the edit form, etc etc etc)

    so I created a query to select the transactions that need to be changed but It wont let me make the changes in the query.



    I used to know and understand this but seem to have lost that knowledge.

    how can I create a query to change the data in these transactions

    in the image below you can see that most of the Transactions are attributed to the "Chapter" OHSTATE (thats who paid the donation)
    and I need to change that to attribute those to the chapters that received the donation like the one that is underlined in red

    Click image for larger version. 

Name:	Capture.jpg 
Views:	22 
Size:	116.3 KB 
ID:	46417

    As always thank you for the help

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Try changing the query to pull the ChapterID from the Transaction table, then see if the query will let you change the ChapterID instead of the ChapterName.
    You probably don't need the TransAccount table in the query at all.

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You don't want to arbitrarily change a chapter name that is related to the chapterID in your chapters table, which is what you're trying to do as far as I can tell.
    If you did that, you'd be changing
    ChapterID ChapterName
    22 OHState

    to
    ChapterID ChapterName
    22 OHRMC-09

    You would want to change the chapterID in transactions. Lucky for you it wasn't allowed - possibly because you either don't have relationships set up or you don't have cascade delete/update set. A db copy would answer a lot of questions but you'll probably solve this without posting that.

    I used to know and understand this but seem to have lost that knowledge.
    For this problem, see http://allenbrowne.com/ser-61.html
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168
    Thank you both for the help, it makes perfect sense now what I was doing wrong.

    and Micron, Yes it did let me do it wrong, messed everything up, luckily I managed to fix it.
    but also Thank You for the AllenBrowne link, this is now bookmarked and in my favorites bar

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You can learn a lot there. Sadly he gave up Access a while back so there's no real new stuff but at least it's still there.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Cannot edit inner query
    By MTM in forum Queries
    Replies: 4
    Last Post: 08-10-2020, 02:43 PM
  2. Can't edit a Group by Query
    By Canadiangal in forum Queries
    Replies: 2
    Last Post: 06-08-2013, 02:12 PM
  3. Replies: 1
    Last Post: 05-31-2013, 08:53 AM
  4. Replies: 1
    Last Post: 09-06-2012, 01:40 PM
  5. Edit a table in a query by renaming the query?
    By TheWolfster in forum Queries
    Replies: 2
    Last Post: 07-30-2010, 02:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums