MS Access combine data from two tables to create one?

Question

I need help with MS access. I have two tables, one with the persons name, address, and account number. The other table i have the persons account number and how much the person donated, and the dates of donation. (could have donated more than one day).

I need to combine the two tables to create a table that shows all of the fields from the first table plus the fields from the second table appended if the account numbers match on both tables.

Can anyone help me or point me in the right direction. Im new with access.

Answer 1

Use the query wizard.. Go to query and start query by wizard and have it walk you through the steps.