I create access queries from design view frequently but have just started working with code. I have a simple query that returns something like this.
ID DSM_IV
1 Autism Spectrum Disorder
1 Communication Disorder (Includes NOS and Unspecified)
2 Reactive Attachment Disorder (RAD)
3 Anxiety...