Replacing rows with data from another table

[EBean]

Hi,


I used to be pretty good at using Access, but it's been about 10 years, and it's not coming back to me as easily as I had hoped.

I have to run a report based on two Tables, but some rows from the 1st Table have to be replaced with data from the 2nd Table, but in a very particular order. Is there a way to do this?

So the first table is a sample of people and answers to questions, and the other table is an oversample of people, in case there are exclusions to the first table. Both tables will have exactly the same data fields.

So say our people are sorted by last name in both tables. There's a field called "Exclusion" (Yes or No). If the answer is "yes" in this field, I need to replace that particular member with a member from the oversample.
The first exclusion in Table 1 is on row 4, and the next exclusion is in row 15.
I need a report or macro or something to replace row 4 in Table 1 with Row 1 in Table 2, and replace row 15 in Table 1 with Row 2 in Table 2.
and so on and so forth until there are no exclusions in Table 1 anymore.

I feel like this is probably really simple, but my brain is apparently mushy from not doing this for so long. Any help is greatly appreciated!

-E

[ranman256]

update query.
bring in both tables to the query , join on key, replace fields needed.