Hello,
I have a query that returns values in about 20 columns. I have two values in columns that I would like to make a pie chart of in a report. I'm trying to find a way to get the data from those two columns into rows in order for the chart to work. Example..
I have:
AirXSegs AirYSegs
767 896
and need a table or query with:
Airline Segments
AirX 767
AirY 896
Any suggestions on how to accomplish via VBA or union query? I can't seem to find anything that has worked yet. Thanks!
I have a query that returns values in about 20 columns. I have two values in columns that I would like to make a pie chart of in a report. I'm trying to find a way to get the data from those two columns into rows in order for the chart to work. Example..
I have:
AirXSegs AirYSegs
767 896
and need a table or query with:
Airline Segments
AirX 767
AirY 896
Any suggestions on how to accomplish via VBA or union query? I can't seem to find anything that has worked yet. Thanks!