Need help with appending data

[RHONDAK72]

This is probably a simple thing but I could use some help...

Let's say I have 2 tables called "A" and "B".
Table "A" has a field called "ENTERED_DT".
Table "B" has a field called "ENTERED_DT_BYR".
Both fields in these tables have the same short date format.

I need to append the value from A.ENTERED_DT to B.ENTERED_DT_BYR.

When I run the append query, the values from table A do not append to table B. How can I do this when the column headings are different?

 

[RHONDAK72]

Cancel that...I just figured it out. You just have to specify the field name into the Apend To row within the query.