Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

MS Access - Combining results from two different queries with different field names and tables 88merlin88 Nov 25, 2003 Jump to latest Follow Reply ...

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.