Query Help

[COforlife]

I have a table where the columns include: ID, Scholarship1, Scholarship2, etc. Under each scholarship heading is either a blank or "Y". What I'm wanting to do is reorganize this list to where I have only two columns: the ID and scholarship name (the heading name in the original table). I'd like to list out all the scholarships (new row for each) where a "Y" is present with the ID that is associated with it. I am obviously struggling with this, so any help you can provide would be appreciated. Thanks.



-Chad

[dcrake]

It appears that your table is not normalised, whereby you should a second table that contains the id of the parent record and an id of the scholarship name, known as the foreign key which is then linked to the primary key in your scholarships table, such as

Parent Table

ID
Other field

Linked Scholarships
Primary Key
Parent Id
Scholarship FK

Scholarships table

Primary Key
Description

David