Hi all--I need some advice on the most efficient way to update a table horizontally. I am creating a table with several columns to accommodate scoring ranges and I'm having some challenges.
Basically, I have an original table with rows of rating scores anywhere from 1-20. I am trying to count how may rows show a score of 1, then place that in the Score 1 column as a subtotal, then a second column for a subtotal of Score 2, and so on. Append queries allow me to subtotal the original data for each score, but then the total is placed a row below the first as you append. It becomes staggered downward rather than all on one horizontal row. Update queries place the data on one row, but don't allow me to subtotal. Is there an easy way to do this without having to create a subtotal query for each score, then an update query for each subtotal? I don't know how to write SQL, so I'm stuck with Access at this point... Close to losing my mind. lol
Basically, I have an original table with rows of rating scores anywhere from 1-20. I am trying to count how may rows show a score of 1, then place that in the Score 1 column as a subtotal, then a second column for a subtotal of Score 2, and so on. Append queries allow me to subtotal the original data for each score, but then the total is placed a row below the first as you append. It becomes staggered downward rather than all on one horizontal row. Update queries place the data on one row, but don't allow me to subtotal. Is there an easy way to do this without having to create a subtotal query for each score, then an update query for each subtotal? I don't know how to write SQL, so I'm stuck with Access at this point... Close to losing my mind. lol
