Okay, it's time to call in the troops

[brendalee2]

I've nearly split my head open trying to figure out this issue, so I've
decided to call upon the experts for some assistance with what could be a
simple database structure problem, or Access quirk I'm not familiar with.

I've created a database which holds respondent answers to a survey aimed at
university donor satisfaction. The first piece I'm trying to extract data
from and report on surrounds the type of gifts a donor has participated in
(annuities, trusts, etc.).

I have drawn CRAT, CRUT, CGA, CLAT, PIF as the gift types from my master
table, and created a query for each that counts the occurrences (respondents
could check as many boxes of the gift types that applied to them---most just
chose one, if they answered at all). The values are CGA-59, CLT-2, CRAT-11,
CRUT-23 and PIF-1.

I'm new to constructing these queries, and totally new to reports. The chart
wizard is totally throwing me off (and so is the design), because I'm not
ending up with the correct data in both the design and the preview modes
sometimes. I also don't understand the Data and Series selections when I'm
going through the wizard. THe end result is that I can end up with a chart
that looks good in design, but previews either with the north south east data,
or a pie chart with just one color/value in it.

HELP!

 

[Duane Hookom]

There is a sample survey application "At Your Survey" available for download
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
demo has a report that includes pie charts of each question. The tables are
normalized which helps the reporting.

 

[brendalee2 via AccessMonster.com]

Thank you very much, Duane. I will study the structure. It looks like the
graphs with statistic summary is exactly what i"m looking to do. NOw I just
have to equate what you did with what i have constructed...

Wish me luck!

There is a sample survey application "At Your Survey" available for download
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
demo has a report that includes pie charts of each question. The tables are
normalized which helps the reporting.

I've nearly split my head open trying to figure out this issue, so I've
decided to call upon the experts for some assistance with what could be a

[quoted text clipped - 20 lines]

HELP!

 

[Duane Hookom]

good luck
--
Duane Hookom
Microsoft Access MVP

Thank you very much, Duane. I will study the structure. It looks like the
graphs with statistic summary is exactly what i"m looking to do. NOw I just
have to equate what you did with what i have constructed...

Wish me luck!

There is a sample survey application "At Your Survey" available for download
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
demo has a report that includes pie charts of each question. The tables are
normalized which helps the reporting.

I've nearly split my head open trying to figure out this issue, so I've
decided to call upon the experts for some assistance with what could be a

[quoted text clipped - 20 lines]

HELP!