Check boxes in reports

[vsteinly]

I have a database that has a field for methods of sustomer notification. I created a form which shows the top methods within our community. Is there a way to have all of these show up as text within a report? Maybe there is a better way to set this up to begin with but I was on a short deadline and couldn't think of anothr way. I have attached the database for suggestions.

 

[JHB]

Try to attach the database again.

 

[vsteinly]

I might add I would like the column in the report to read "Method(s) of Customer Notification" and the data to shows as follows "Nixle, Twitter, News Media". So if more than method was used all will show.

Thanks for looking at this for me.

 

[JHB]

Have you made the report in the attached database?
Where should the "the column in the report to read "Method(s) of Customer Notification" come from, in a quick overview I can't find a field called that?
I don't think your database is normalised.

 

[vsteinly]

That would be a column header "Method(s) of Customer Notification" in the report. I looking to have the fields below show in that column:

Nixle
Twitter
Media
Radio
Personal Contact
Phone

These are setup as yes/no fields.

 

[JHB]

To help you further, I need a printscreen how the result should looks like.

 

[vsteinly]

Here is how I would want it to look.

 

[JHB]

Because of your database isn't normalised, you need to find a other way to get the data, I've use a UDF function in the query.
The database is attached.

 

[vsteinly]

That's looks perfect. This is just a quick fix for something that will be collected on a bigger scale once an upgrade is finished. Thanks, you have shown me something new!!!

 

[JHB]

You're welcome, luck with your project.
Did you read my signature?

 

[vsteinly]

Think I'm missing something?