Access 2013: Merging the same table-field with different data I have six tables with identical fields. the group was tasked to input the data with the same fields and I need to merge all into one dataset--- table and form.
create a view likes this:

    select * from table1
    union
    select * from table2
    union
    ...
    select * from table6