Charts

[Robb - STF]

Can not get rid of "SumOf", when I go into rowsource and change it, I get a
some kind of circular error, also it is right in disign view then when I
change to preview it goes back to "SumOf"XXXX. Please help, this is driving
me NUTS.

 

[Duane Hookom]

Come back with your current Row Source SQL and the exact label you want to
display.

 

[Robb - STF]

I guess I don't understand what you are saying - come back???

SELECT Null AS Expr1, Sum([2005 New Sale AAP]) AS [SumOf2005 New Sale AAP],
Sum([2006 New Sale AAP]) AS [SumOf2006 New Sale AAP], Sum([2007 New Sale
AAP]) AS [SumOf2007 New Sale AAP]
FROM [Pricing History Detail];

I want it to read "2005 New Sale AAP"

 

[Duane Hookom]

"Come back with" is like "reply back with".

You can't use a name for the column that is already being used. Try
something like:

SELECT Null AS Expr1, Sum([2005 New Sale AAP]) AS [2005 - New Sale AAP],
Sum([2006 New Sale AAP]) AS [SumOf2006 New Sale AAP], Sum([2007 New Sale
AAP]) AS [2007 - New Sale AAP]
FROM [Pricing History Detail];

--
Duane Hookom
Microsoft Access MVP

I guess I don't understand what you are saying - come back???

SELECT Null AS Expr1, Sum([2005 New Sale AAP]) AS [SumOf2005 New Sale AAP],
Sum([2006 New Sale AAP]) AS [SumOf2006 New Sale AAP], Sum([2007 New Sale
AAP]) AS [SumOf2007 New Sale AAP]
FROM [Pricing History Detail];

I want it to read "2005 New Sale AAP"

Come back with your current Row Source SQL and the exact label you want to
display.

 

[Robb - STF]

Thanks, that did it!

"Come back with" is like "reply back with".

You can't use a name for the column that is already being used. Try
something like:

SELECT Null AS Expr1, Sum([2005 New Sale AAP]) AS [2005 - New Sale AAP],
Sum([2006 New Sale AAP]) AS [SumOf2006 New Sale AAP], Sum([2007 New Sale
AAP]) AS [2007 - New Sale AAP]
FROM [Pricing History Detail];

--
Duane Hookom
Microsoft Access MVP

I guess I don't understand what you are saying - come back???

SELECT Null AS Expr1, Sum([2005 New Sale AAP]) AS [SumOf2005 New Sale AAP],
Sum([2006 New Sale AAP]) AS [SumOf2006 New Sale AAP], Sum([2007 New Sale
AAP]) AS [SumOf2007 New Sale AAP]
FROM [Pricing History Detail];

I want it to read "2005 New Sale AAP"

Come back with your current Row Source SQL and the exact label you want to
display.

--
Duane Hookom
Microsoft Access MVP


:

Can not get rid of "SumOf", when I go into rowsource and change it, I get a
some kind of circular error, also it is right in disign view then when I
change to preview it goes back to "SumOf"XXXX. Please help, this is driving
me NUTS.