Hi,
Sorry if I was not clear.
I will redefine my requirement now. I have a graph which displays numbers
from "<-10",-10,-9,-8,...... +9,+10,>+10 in the X-Axis and the
corresponding
percentages will be plotted . The Y-axis displays the scale for plotting
this
values.
I am also displaying the data table for Graph. The Data table looks as
below.
-----------------------------------------------------------------------------------------------
<-10 -10 -9 ........-2 -1 0 +1
+2 ..... +10 >+10
Total 0.2% 1.5% 3.3% 4.5% 2.3% 23.4% 20.5% 3.2% 9.8%
11.5%
------------------------------------------------------------------------------------------------
The query I used got the result . But , as shown above, I want the Numbers
in X-Axis to be displayed along with the sign .Currently the sign is
being
displayed for negative numbers and not for positive numbers.Formatting the
data sheet yields no result.
Please help me.
Duane Hookom said:
I'm even more confused.
- I would replace all those nested IIf()s with the Switch() function or
a
user-defined function.
- I would not alias a calculation with the name of an existing field
--
Duane Hookom
MS Access MVP
message Thanks.
The query already have an alias for the column. My query is as below.
SELECT
IIf(tempGraph.StkdRange=-11,"<-10",IIf(tempGraph.StkdRange=11,">10",IIf(tempGraph.StkdRange=0,"Plan
InDC",iif(tempGraph.StkdRange > 0 ,"+" & tempGraph.StkdRange ,
tempGraph.StkdRange)))) AS StkdRange,
Format((Sum([tempGraph].[StkdRangePercent])),"0.0%") AS Total FROM
tempGraph
GROUP BY tempGraph.StkdRange, tempGraph.SortKey ORDER BY
tempGraph.StkdRange;
The stkdRange will be displayed in the X axis and the Total will be
plotted
in the graph . Basically I want the stkdRange to display the positive
numbers
with Sign.
This doesn't happen in the graph and the positive numbers are still
showing
up without sign. Thought formaing that column as text in the data sheet
will
do that but don't know how to refer that column.
Please let me know the way to do it.
:
Have you considered aliasing the column heading in the query?
MyNewTitle: [StkdRange]
--
Duane Hookom
MS Access MVP
--
in
message Hi,
I want to format the title column of Graph data sheet. Example is
The datasheet looks like this
StkdRange A B C D E F G H I J K L
----------------------------------------------------------------
1 <-10 1.0%
2 -10 2.3%
3 -9 3.3%
4 -8 4.5%
5 -7 5.6%
6 -6 1.3%
How do I refer the column before the column A in the VBA code?
Thanks in advance for your time.
