Search results

And what about SQL? I was hoping I could pick up a SQL trick that would query my data into the table I need. Is this possible?

Hi Plog - thanks for the insight. It's something I've been struggling with for a while. I've seen data stored like this in several different places (from data sources that I cannot control). In the past I've done what you suggest (not because I thought it was the right thing, I actually...

Hi all. Please help I have a table with application records. One of the fields captures schools the applicant will work at. This field stores data in comma delimited format. There could be 1 school name; there could be 5 school names. My ultimate goal is to build a report which shows me...

Hmm interesting. OK. Each record has one ID and one response. Then I have 10 fields - all of which are Boolean. Records can be true in multiple fields and must be true in at least 1 field. The objective is to display all of the responses for field 1 where their value is true. Then, display...

Please help. Here's my scenario. I have data from a survey with qualitative responses. For a single qualitative question, I moved the ID & responses into a new table and categorized the response according to a bucket/theme, where each column is a new bucket. I now have 10 columns. Each response...