I have a table that I want to utilize 6 Fields...1 [Name], [Reason1], [Reason2], [Reason3], [Reason4], [Reason5].
Basically, the Reasons could contain all the same values, just in prioritized differently and possibly blank.
I am able to create a query that will list [Name] as the Column Header and [Reason 1] as the Row Header...with the associated counts displayed
Ideally, I would want to have Reasons 1-5 consolidated as the Row Header and to indicate the count of each instance that the [Name]/person used that [Reason].
On a side note, I would like to have this as 1 SQL/Query so that I can utilize it via Excel/ADO.
Thanks!
Basically, the Reasons could contain all the same values, just in prioritized differently and possibly blank.
I am able to create a query that will list [Name] as the Column Header and [Reason 1] as the Row Header...with the associated counts displayed
Ideally, I would want to have Reasons 1-5 consolidated as the Row Header and to indicate the count of each instance that the [Name]/person used that [Reason].
On a side note, I would like to have this as 1 SQL/Query so that I can utilize it via Excel/ADO.
Thanks!
