Prev: Can't open my Access files after conversion from Access 97 to Access 2003
Next: extract part of email after @
From: BarryL on 9 Apr 2010 22:15 I have used a query as the row source for a chart. The query generates a number with multiple decimal places. When I edit the chart I can format the number in the data sheet but when I save the chart and view it the number format is lost. I can format the number in the query using a formatnumber expression but I want to use the query as a source for another query which calls for a number rather than text. Is there a way to make the number formating in the chart datasheet stick?
From: Duane Hookom on 10 Apr 2010 00:27
Have you considered using a subreport rather than a chart datasheet? You would have much greater control over the layout. -- Duane Hookom MS Access MVP "BarryL" <BarryL(a)discussions.microsoft.com> wrote in message news:F675C94D-D48E-4EE8-833C-F8EEC6E456DE(a)microsoft.com... > I have used a query as the row source for a chart. The query generates > a > number with multiple decimal places. When I edit the chart I can format > the > number in the data sheet but when I save the chart and view it the number > format is lost. I can format the number in the query using a formatnumber > expression but I want to use the query as a source for another query which > calls for a number rather than text. Is there a way to make the number > formating in the chart datasheet stick? |