Summarizing Logical Field Data

[tallbarb]

A user set up a database with all logical data types for a variety of questions. For instance, he has a table called "Was the Training Useful" with the following logical fields:

Not at all
A little
Somewhat
Mostly
Very

Now, I want to create a column chart in Access XP showing a count for only the TRUE values for all 5 of these fields. For instance, of the 100 attendees, 10 marked Not at All as true, 10 marked A litte as true, 50 marked Somewhat as true, 20 marked Mostly as true and 10 marked Very as true. I'd like to have a legend with the field names and a column chart that shows the values of TRUE for each field.

I swear, I have tried so many things that haven't worked, it's driving me nuts. I have a feeling I'm not seeing the forest for the trees. I assume I need to start with a query that somehow totals all these "true" values - but I can't get that to work either without splitting each question into a separate query, grouping, and then doing a total column for the same field.

I sure could use some help on how to make this work. I feel like an idiot - I know this should be simple (and I am trying not to break down and move all this into Excel) - but my brain refuses to see the answer! Help, help, help - and thank you!!

 

[Blorf]

Try using an if statement for each logical field.

In your query, instead of calling the logic fields, use something like this:

NAA : iif ([Not at all] = true, 1, 0)

Then sum the fields.

ChaZ


Ascii dumb question, get a dumb Ansi

 

[tallbarb]

I found something in the FAQs that worked, too. And it was just as simple as I had thought - I feel SOOOO duhhhh! Simply sum the fields in the query and then use the abs function to display the value.

What would I do without this forum!!

Thank you!

 

[dhookom]

tallbarb,
The table structure you are using is highly un-normalized. You might want to look at the "At Your Survey" demo found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.