Hello Folks,
Our organization has a mdb used to track all donations. I've been trying to put a query together that will show all donors and their donations for the past three years (the years cannot be hard coded because it will be used for years to come).
The mdb structure is as following:
tblDonors includes the following fields:
ID (PK)
Surname
First Name
City
Country
tblDonations includes the following fields:
ID
Amount
CivilMonth
CivilYear
The query I'm trying to make should show all info from tblDonors, and in addition three more columns, each for one of the last three years.
Our organization has a mdb used to track all donations. I've been trying to put a query together that will show all donors and their donations for the past three years (the years cannot be hard coded because it will be used for years to come).
The mdb structure is as following:
tblDonors includes the following fields:
ID (PK)
Surname
First Name
City
Country
tblDonations includes the following fields:
ID
Amount
CivilMonth
CivilYear
The query I'm trying to make should show all info from tblDonors, and in addition three more columns, each for one of the last three years.