Re: Help with Report from 5 Tables

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 04/24/04 

Date: Sat, 24 Apr 2004 12:12:29 -0500

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
"Hadi Lalani" <hlalani@ltechs.com> wrote in message
news:A038C91A-5C17-403A-A6A0-1862B402AA29@microsoft.com...
> 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.
>
> Thanks
>
> Sincerely
>
> Hadi Lalani
>
>
>

Relevant Pages

  • Re: Format report, fixed height for entries that must shrink?
    ... Donor table looks good ... So your report would have one field that showed all the items in the list that were donated. ... Dim rstAny As DAO.Recordseet ... If I've coded the above function correctly you should get something back for the Donation list that could look like the following. ...
    (microsoft.public.access.gettingstarted)
  • Re: Format report, fixed height for entries that must shrink?
    ... customers donate regularly, and I only want 1 entry per donor, even if they ... transaction details have to be typed in (date of donation, items, special ... go through a routine run the queries, routing import and the report printing. ... customers when they donate items to our organization. ...
    (microsoft.public.access.gettingstarted)
  • Re: Format report, fixed height for entries that must shrink?
    ... And once you get your design worked out, you can post back here and ask for advice. ... Donor table looks good ... So your report would have one field that showed all the items in the list that were donated. ... If I've coded the above function correctly you should get something back for the Donation list that could look like the following. ...
    (microsoft.public.access.gettingstarted)
  • Re: Format report, fixed height for entries that must shrink?
    ... Donor table looks good ... Dim rstAny As DAO.Recordseet ... -- Select the donor fields you want on the report ... for the Donation list that could look like the following. ...
    (microsoft.public.access.gettingstarted)
  • Re: Format report, fixed height for entries that must shrink?
    ... Your first problem seems to be that your data structure is wrong. ... add another donation category you won't have to rewrite all your forms, ... customers when they donate items to our organization. ... for several weeks to find a way to format this report so that each entry ...
    (microsoft.public.access.gettingstarted)