Hi All,
I have 4 tables (Contract Value, Project manager, Expenses, Closed Projects)that i am pulling information from and combining in 1 table. the single table is called Master Table
I am using an append query for each of these and i would like the append query to insert a field at the end of each record with the table name it originated from in it if possible.