build a query about donations now the below picture is where the help with this that I have gotten earlier have not worked out so here I will explain it a little more indepth and I will provide pictures.

 

A File Home Create External Data Database Tools View Run DonationLetter PSP4: Database- C\Users hska OneDrive Pictures DonationLetter PSP4.accdb (Access 2007-2016 file format) - Access Results Save All Access Obj... < Search... Tables Donors Year 1 Donations Year 2 Donations Year 2 Letter Queries Donors Query Form View Select Make Append Update Crosstab Delete Table Query Type Donors Query X Year 2 Donations or: Donor Num Donation. Field: Donor Num Table: Donors Sort: Show: Criteria: Help Donors x Union Query Design Pass-Through Data Definition Last Name Donors h Donors Donor Num Last Name First Name Gender Zip +T P Add Tables First Name Donors h Tell me what you want to do Insert Rows Ex Delete Rows Builder Query Setup LJ Insert Columns LIJ Delete Columns Return: All Year 1 Donations * Donor Num Donation Donation Year 1 Donations Donation Year 2 Donations Descending GoM Totals Parameters C Property Sheet Table Names Show/Hide n P P ryan skaggs RS n Num Lock EFFA 0 C SQL X A