Comma Delimited List Query/Report

[scrapyard]

Hmm,

I know this has likely been posted a lot, but sifting through the similar posts has been as confusing as trying to find the answer elsewhere on the web.

I have created a (radio listener) survey using Access. In the survey, I created a multi-select combo box, "Station 1, Station 2, Station 3, etc., Station 7" which stores the data in column "Familiar."

Now that the 199 surveys have been completed, I'm trying to create queries/reports with the data. (To show which radio stations are listened to in which area, among other things.) However, I cannot figure out for the life of me how to extrapolate the data. I'm simply not sure on the code for SQL or how to design the query.



The end result would be a pie chart indicating the percentage of the 199 records (surveys) contain "Station 1, etc." in that column.

(Later I will add the "area" criteria.)

Any help you can offer would be exceptionally useful.

[AdventureBob]

The Query is realtively easy. Open a qry with that table. Drop familiar on the grid at the bottom twice. Hit the summation btn at the top. change the second Familair field to count and make sure the other is group by. It will count the number of times that entryis in your data set.
Station 1 32
station 2 54
Station 3 12
....

[scrapyard]

Thank you for your help!

I thought this would be easy...

I get an error:
The multi-valued field '[Survey Table].Familiar' cannot be used in an GROUP BY clause.

When I change the "Group By" I get a column "CountOfFamiliar", which counts each value in the row. I get a number of rows equal to the number of surveys.

[scrapyard]

Okay,

I had to use Familiar.value and that worked!

Thanks!!!