Below is the structure of my tables

Table Donorinfo
CustID
Firstname
Lastname
Region
Phone

Table Donations
DonationdID
custId
ProjectId
VolunteerId
DonationDate
Donationamount

Table Project
ProjectId
ProjectDesc

Table Volunteer
VolunteerId
VolunteerName

My Tables are related as follows
Donorinfo is related to Donations with Custid
Donations is related to Project with ProjectID
Donations is related to Volunteer with VolunteerId

Below is the sample of my Data for a record with a 2003 date

CustId -- 1234
Lastname -- Lalani
firstName-- Hadi
Donationsdate-- 4/1/2003
DonationsAmount-- 1000.00
Volunteer--- Andy
ProjectDesc---2003

Below is the sample of my date with a record of 2004 data

CustId -- 1234
Lastname -- Lalani
firstName-- Hadi
Donationsdate-- 4/1/2004
DonationsAmount-- 500.00
Volunteer--- Andy
ProjectDesc---2004

i want to createa report that will show in one line all the details
below, each field shuld be a column

Lastname--- Lalani
Firstname---Hadi
ProjectDesc---2003
Donationsdate---4/1/2003
Donationamount----1000.00
Volunteer--Andy
Projectdesc---2004
Donationdate----4/1/2004
Donationamount-----500.00
volunteer---Andy
Projectdesc-----2004

This will help me identify if a Donor has given a different amount in
2004 than 2003 and also if a Donor has not pledged anything in 2004 as
compared to 2003.

Thanks for all your assistance

Sincerely

Hadi Lalani