Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to label a graph based on the results of a Union query

Status
Not open for further replies.

AaronConcannon

Technical User
Jan 24, 2001
13
GB
Hi,

I'm using a union query to combine the results of 8 queries into a single column so that I can produce a bar chart. The problem I have is that the bars are currently Labelled as "column 1" "Column 2" and so on. Without proper labeling the chart is basicly useless.

Each of the 8 queries that form the union query always produces a single value (the value may change, but there is never more than 1 value)

The column labels will always remain consistant.

How can I get access to label the columns correctly?

TIA

Aaron
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top