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.

Additional Details

the wizard is not giving me what i am looking for. I need to append the payment amounts to the first table[Donor] table. Its duplicating the donor name if they gave more than one time. I need it to return the Donor name once and keep appending the amounts for that donor to the same row. Right now if he gave 5 different times, his name is coming up in the query 5 times. I dont want that.

Answer 1

Best Answer - Chosen by Voters

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