Append Query help

[Pancakes1032]

Hi All,

I am creating an Append Query that will combine multiple table's data and add it to an existing table that has a field called MR. This MR has a drop down with the names of the tables that this data is coming from. Would it be possible if the data that is pasting in the row from the append query would indicated which table it originated from in the MR field?

I hope that makes sense.

Thank you!

[jonh]

No

[jonh]

Or yes.

It depends on the query.

[Pancakes1032]

I actually figured this one out too. I did the append query with the data and then I did an update query to add the "MR Report Name" into the appropriate field in the table.