Results 1 to 2 of 2
  1. #1
    lw1990 is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    5

    How to optionally put a value in multiple rows simultaneously based on a common column value?

    The following sample table (Table1) has some repeating GroupName values (Group1 repeats 3 times, Group4 repeats twice) and some repeating questions (Question1 occurs 4 times, Question2 occurs twice).
    The answers may be the same for identical questions, or different, if they are in a different group. Group1 may have an answer to Question1 of "Answer1" or "Answer2" or "Answer999" etc. Group2 may have an answer to Question1 identical to the above, or different. Usually, the answers are the same though, so it would be helpful when you have 10,000 rows like this to say "this is a typical answer, apply this answer to all identical questions except the ones I exempt".
    Here is a snapshot of my example table:






    Now, this could easily be accomplished with some sloppy VBA to just copy the values to all identical rows except ones specified in a pop up of some kind, but that isn't very user friendly. I'm looking for a more robust/native/normalized way to organize and present this data for data-entry users so that they can view, for example, all Question1's in their own table/form and answer them for multiple rows (varying Groups) in one user action.
    Any help greatly appreciated!
    Here is a download of the sample database:

    http://www.filedropper.com/question1_1
    Last edited by lw1990; 03-14-2015 at 03:16 AM.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    part of the solution lies in how the user interface (form) is designed; but in terms of table design where there is going to be general 'select all' but ability to un-select some manually - then you will want a check box field as part of the table structure to work with.

    then there is another level where one is going to trigger Append Queries for rows that have the check box checked. It is a multi part solution.

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

Similar Threads

  1. Replies: 4
    Last Post: 03-10-2015, 08:26 AM
  2. Replies: 4
    Last Post: 04-22-2014, 08:23 AM
  3. Replies: 1
    Last Post: 07-30-2013, 06:33 AM
  4. the cells that some rows have in common
    By analarana in forum Access
    Replies: 3
    Last Post: 06-11-2013, 02:33 PM
  5. Combine datatable rows based in common value
    By pipelian in forum Access
    Replies: 1
    Last Post: 11-27-2012, 10:20 AM

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