Help with Report from 5 Tables

[Hadi Lalani]

I am trying to assist our church with some Access Reporting. I do nto claim to be an expert but am trying to do the best I can.

I posted the same question earlier but did not get detailed responses

Below is waht i am trying to achiev

I have 5 table

Donor Info Table has the following field
Regio
Last Nam
First Nam
Telephone

Donation Details Table has the folowing field
Donation Dat
Donation Amoun

Volunteer Table has the folowing field
Volunteer Nam

Project Table has the following field
Project Description = 2003 or 200

All the tables have the valid relationship and i am ok with that part. I am trying to pull a report with all the fields that I have above. When i run the report as created, i am getting one or two records for each person depending if they have a record for 2003 or for both 2003 and 2004. what I am trying to achieve is to have 2 columns one for 2003 and one for 2004 in my report if the donor has 2 records in the Project Description Table. If the Donor only record for eithe 2003 or 2004 then I want the report to populate only that column

Below is the desired layout for my repor

Region
LAstnam
Firstnam
Phone
Project Descriptio
Donatin Dat
Donation Amoun
Project Description
Donation Dat
Donation Amoun

Any and all assistance will be greatly appreciated. I have been strugglign with this for almost a week and could really use some detail instructions or write on how to achieve this task

Thank

Sincerel

Hadi Lalan

 

[Duane Hookom]

Maybe you aren't getting help since
-your Project table has no relationship to any of your other tables.
-your DonationDetails table has no relationship to the DonorInfo table
-you state you have 5 tables and only described 4

You must try to understand that we can't see your tables, fields, or data
examples.

--
Duane Hookom
MS Access MVP

I am trying to assist our church with some Access Reporting. I do nto

claim to be an expert but am trying to do the best I can.

I posted the same question earlier but did not get detailed responses.

Below is waht i am trying to achieve

I have 5 tables

Donor Info Table has the following fields
Region
Last Name
First Name
Telephone #

Donation Details Table has the folowing fields
Donation Date
Donation Amount

Volunteer Table has the folowing fields
Volunteer Name

Project Table has the following fields
Project Description = 2003 or 2004

All the tables have the valid relationship and i am ok with that part. I

am trying to pull a report with all the fields that I have above. When i run
the report as created, i am getting one or two records for each person
depending if they have a record for 2003 or for both 2003 and 2004. what I
am trying to achieve is to have 2 columns one for 2003 and one for 2004 in
my report if the donor has 2 records in the Project Description Table. If
the Donor only record for eithe 2003 or 2004 then I want the report to
populate only that column.

Below is the desired layout for my report

Region
LAstname
Firstname
Phone #
Project Description
Donatin Date
Donation Amount
Project Description
Donation Date
Donation Amount

Any and all assistance will be greatly appreciated. I have been strugglign

with this for almost a week and could really use some detail instructions or
write on how to achieve this task.

 

[Hadi Lalani]

i am sorry i have 4 Tables

i have all the tables linked and have a report that shows 2 records per person if the person has a record for 2003 and 2004 and one record per person if the person has one record either for 2003 or 2004

Hope this help

Hadi

 

[Duane Hookom]

This was very little help. We still don't know:
-how the tables are related
-a sample of your actual data

If you don't have the time to explain this or copy a few records into a
reply, you will find that others won't have time to make guesses at
solutions. Personally, I'm losing interest since I don't have lots of extra
time to continue making simple requests and not getting answers.

--
Duane Hookom
MS Access MVP

i am sorry i have 4 Tables.

i have all the tables linked and have a report that shows 2 records per

person if the person has a record for 2003 and 2004 and one record per
person if the person has one record either for 2003 or 2004.

 

[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]

I would create a main report of table DonorInfo only. Then create a query of
Donations and Project and set the criteria to your specific ProjectDesc
values. Use the donations query as the record source for a 2 (or more)
column report that you would use as a subreport on the main report. Set the
Link Master/Child properties of the subreport control to the CustID field.

--
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.

 

[Hadi Lalani]

Duane

Thanks for yoru suggestions. FYI, I am trying to do this for our Church for their fundraising drive to meet annual expenses

i understnad about creating a main report for the Donorinfoand the query and also about the query of Donations and Project and the criteria

what ihave a question on is part 3 where you suggested to use the donations query as the reoord source for a 2 or more column report (which i understand also). What i am not clear is the part about "use as a subreport on the main report. Set the link Master/Child properties of the subreport control to the CustId field

Can you please explain the last part to me maybe in a little bit more details. I amnot sure, if you would be willing to talk to me, and if that is acceptabel to you, i can call you no matter where you are.

I really appreciate your assistance,

Sincerel

Hadi Lalani

 

[Duane Hookom]

You might want to look at the Northwind sample database. There is a catalog
report and subreport that links on category ID or similar.

--
Duane Hookom
MS Access MVP

Duane,

Thanks for yoru suggestions. FYI, I am trying to do this for our Church

for their fundraising drive to meet annual expenses.

i understnad about creating a main report for the Donorinfoand the query

and also about the query of Donations and Project and the criteria.

what ihave a question on is part 3 where you suggested to use the

donations query as the reoord source for a 2 or more column report (which i
understand also). What i am not clear is the part about "use as a subreport
on the main report. Set the link Master/Child properties of the subreport
control to the CustId field.

Can you please explain the last part to me maybe in a little bit more

details. I amnot sure, if you would be willing to talk to me, and if that is
acceptabel to you, i can call you no matter where you are.

 

[Hadi Lalani]

Ok, I have created the report as suggested by you and also a sub report and am getting the required results

I am not sure what else i can d

Had

 

[Hadi Lalani]

correctio

Am not getting the required result

Thank

 

[tina]

i'm willing to look at your db and try to "fix" the problem, then send it
back so you can see what i did. if you want me to, make a copy of your db
and do the following *to the copy*:

1. remove proprietary data (names, addresses, phone numbers, etc), and
*replace* with fake data - so i have something to work with.
2. compact the db.
3. zip the db to under 1 MB. i have WinZip at this end to unzip.
4. attach to an email, and refer to the MS newsgroups in the Subject line.
5. paste the newsgroups posts into the email body, so i know what's going
on.
6. email to me at ttacc_kill_all_spam_ess1 at yahoo dot com, removing the
underscores and all words between them.
i'll look at the db and try to get back to you within a day or two.

 

[Duane Hookom]

If you can't provide use with more information about what you are
experiencing that is wrong, we can't help you. Maybe tina can find a
solution if you send her the file.

 

[Hadi Lalani]

I alreayd emailed her the fil

thank