append query? (1 Viewer)

[maggiemaxima]

I need an "append query for each table to put it into the new consolidated table." how do i create a apeend query?

 

[Hayley Baxter]

create a query as normal and in design view change the type to append which is available from the toolbar.

Next choose the appropriate table name(s), fields and criteria for appending the records.

HTH
Hay