Report from Mulyiple Tables in a Column Format

[Hadi Lalani]

Below is the structure of my table

Table Donorinf
CustI
Firstnam
Lastnam
Regio
Phon

Table Donation
DonationdI
custI
ProjectI
VolunteerI
DonationDat
Conationamoun

Table Projec
ProjectI
ProjectDes

Table Voluntee
VolunteerI
VolunteerNam

My Tables are related as follow
Donorinfo is related to Donations with Custi
Donations is related to Project with ProjectI
Donations is related to Volunteer with VolunteerI

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

CustId -- 123
Lastname -- Lalan
firstName-- Had
Donationsdate-- 4/1/2003
DonationsAmount-- 1000.0
Volunteer--- And
ProjectDesc---200

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

CustId -- 123
Lastname -- Lalan
firstName-- Had
Donationsdate-- 4/1/2004
DonationsAmount-- 500.0
Volunteer--- And
ProjectDesc---200

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

Lastname--- Lalan
Firstname---Had
ProjectDesc---200
Donationsdate---4/1/200
Donationamount----1000.0
Volunteer--And
Projectdesc---200
Donationdate----4/1/200
Donationamount-----500.0
volunteer---And
Projectdesc-----200

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 assistanc

Sincerel

Had

 

[Duane Hookom]

There is a recent reply to a previous thread with your same question. Please
don't start new threads when the question is being addressed in another
thread.

--
Duane Hookom
MS Access MVP
--

Below is the structure of my tables

Table Donorinfo
CustID
Firstname
Lastname
Region
Phone

Table Donations
DonationdID
custId
ProjectId
VolunteerId
DonationDate
Conationamount

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.