Need URGENT Report HELP- 2nd Request PLEASE

H

Hadi Lalani

I am really desperate and need some HELP. I had posted this request earlier and the replies that i received are nto working for me. I am not sure why is this so difficult to get done

Below is my reques

Below is the structure of my table

Table Donorinf
CustI
Firstnam
Lastnam
Regio
Phon

Table Donation
DonationdI
custI
ProjectI
VolunteerI
DonationDat
Donationamoun

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 detail
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 i
2004 than 2003 and also if a Donor has not pledged anything in 2004 a
compared to 2003

Thanks for all your assistanc

Sincerel

Hadi Lalan
 
D

Duane Hookom

I posted some suggestions in another thread and your reply was "Ok, I have
created the report as suggested by you and also a sub report and am getting
the required results." Doesn't this mean your issue has been resolved or is
there something else?


--
Duane Hookom
MS Access MVP


Hadi Lalani said:
I am really desperate and need some HELP. I had posted this request
Click to expand...
earlier and the replies that i received are nto working for me. I am not
sure why is this so difficult to get done.
 
A

amishra

U are trying to get rows as colums based on the report layout u needed
in basic reports its not possible. use crosstab query to create a quer
and then create a report based on that query.

Hope it helps.

Ami
 
A

amishra

U are trying to get rows as colums based on the report layout u needed
in basic reports its not possible. use crosstab query to create a quer
and then create a report based on that query.

Hope it helps.

Ami
 
A

amishra

U are trying to get rows as colums based on the report layout u needed
in basic reports its not possible. use crosstab query to create a quer
and then create a report based on that query.

Hope it helps.

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 
A

amishra

1. create a simple query called as "QryDonations"
see below

SELECT Donorinfo.CustID, Donorinfo.FirstName, Donorinfo.Lastname
Project.ProjectId, Project.ProjectDesc, Volunteer.VolunteerId
Volunteer.VolunteerName, Donations.DonationdID, Donations.DonationDate
Donations.Donationamount
FROM Volunteer INNER JOIN (Project INNER JOIN (Donations INNER JOI
Donorinfo ON Donations.custId = Donorinfo.CustID) ON Project.ProjectI
= Donations.ProjectId) ON Volunteer.VolunteerId
Donations.VolunteerId;

2. create a crosstab query called as "QryDonations_Crosstab"

TRANSFORM Sum(QryDonations.Donationamount) AS SumOfDonationamount
SELECT QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
FROM QryDonations
GROUP BY QryDonations.CustID, QryDonations.FirstName
QryDonations.Lastname, QryDonations.VolunteerName
PIVOT QryDonations.ProjectDesc;

Runs the sec query u can see the desired output .
keep in mind instead of showing projdec as title of colum it wil tell
2003, 2004 as column title.

I hope this clears u r doubt

Ami
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report from Mulyiple Tables in a Column Format 1
Help with Report from 5 Tables 12

Top