'MS-access append query for specific column

how can I use access append query for specific column for empty existing table contain same column and many other column include calculated columns ?



Solution 1:[1]

Attached are images showing how to use append query to insert records from one table into another, including a calculated column.

The sample uses TableA(Table with existing records) and TableB table with no records, but similar columns has TableA.

TableA

TableB with no record

Append Query design view

TableB with inserted records after running append query

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Sola Oshinowo