Thread: *HELP* Pulling Report

I have a form with several fields: Name, ID, Email, A, B, C, D

I want to pull a report that will pull all the Names, ID, Email and only the letters that have an X in their corresponding column. So it would look similar to:

Name, ID, Email, C (This person only had an X in the C field)
Name, ID, Email, A, D (This person had an X in the A and D field)
Etc etc...

Thanks, any help would be appreciated. I am somewhat new to Access.