I have what should be a relatively simple question. I apologize for not providing an Access attachment; but I am having problems opening any updated Access attachments that are sent back to me. I have attached an Excel Spreadsheet that should effectively illustrate what I would like to accomplish:
Essentially, I have 2 tables (Table1 and Table2) which are already pre-populated with 3 record-sets of data.
1. I would like to create a 3rd table (Table3) that auto-populates based on and if certain conditions are met from the other two tables. If the condition is met, the designated field should be populated with “Delete—“, if the condition is not met, the designated should simply remain blank.
2. I would also like to ensure that record-sets in my new Table (Table3) are in sync with the record-sets in Table 1 and Table 2 (a friend already linked the records sets of Table1 and Table2 together—although I’m not sure how he did it; so I’m only concerned with syncing up Table3).
I know the basics of Access, but I don’t have a lot of experience in some of these more customized/complicated tasks… so if someone could hold my hand and give me step-by-step instructions on how to make this happen, it would be most appreciated.
Please review the attached Spreadsheet. You will notice that there are 3 conditions I’d like to program into this Table:
If Question1 = 1; then Condition3 = "Delete--" Otherwise, Condition3 = ""
If Question1 = 2, Question4 = 4 AND Question6 = 2; then Condition1 = "Delete--" Otherwise, Condition1 = ""
If Question4 = 2, Question5 = 1 OR Question8 = 2; then Condition2 = --"Delete--" Otherwise, Condition2 = ""