I'm working with an existing dataset from excel and need to change the setup of alot of the data in order to get what i need. One table has attendance data but it is broken up by session number---so id, show1, show2, etc...with 1's and 0's. I would rather have multiple records per person and the dates, so, id, show date. Is there an easy way to manipulate the data to do this?
Otherwise, i need to write code to search through all of the [show#] fields..there are about 15, to look for a string of text.
Anyone have any good suggestion on how to either one of these things? Thanks!
Well, ultimately i want to be able to tell how many sessions they were eligible for...based on what already exists: 1=attended,0=did not attend, W=withdrew. So i think it would be easiest to change the data setup from [person], [show1],[show2]...etc. TO [person], [show]---this would have the show dates (that would come from a lookup table). Is that any clearer?
Thanks, this is helpful. I'm kind of lost on how to add in a field that shows which show # it is. Otherwise i just have all 0's and 1's, but am not sure which show it goes with. I tried to write in SQL a right() on [show1] AS show3, but that didn't work.