OK, the database, like I said has multiple columns and some of them
have pre-determined selections in a drop-down box. These fields are
mixed in amongst other free-form text fields. I need to generate a
series of bar graphs that show the number of each possible response for
these fields. The fields are named according to the possible responses
on a written survey. So, you might have a question that says "How do
you feel about these aspects to your job:", then a sub-question that
asks "Pay is good", and then possible reponses of "Excellent", "Good",
"Fair", "Poor", "No Comment". Here is how the data looks in the
database:

Name |Pay |Working Conditions
|Advancement Opportunities
-----------------------------------------------------------------------------------------------------------------------------------------------
John Q. Public |Excellent |Fair
|Good
Jane Q. Public |Poor |No Comment
|Good
Jim Q. Public |Excellent |Good
|(blank)

These fields are mixed in with other text fields to handle comments for
each of these questions. Each record also has an index value. I have
also created a table that only has a single field and contains the
possible responses to these questions, i.e.

| Field
------------------
|Excellent
|Good
|Fair
|Poor
|No Comment

I suppose the question to ask instead of how to fix what I've done, is
how to make a series of bar graphs to show the number of each possible
response to each of these questions. When I try to import, I use the
PivotTable and PivotChart wizard, external data source, Get Data, MS
Access Database, select the .mdb file on the network, then it asks me
what columns I want to include. I think this is the point that I'm not
sure of what to do. Any help is appreciated.

Thanks!