I am creating a report from a query. I have asked previously how to show
months instead of the month number. With a little help from this newsgroup,
that part is fixed. Now I cannot seem to sort the months by month order, it
is only being sorted alphabetically. Is it possible to sort by month order
on the chart.

How can I format the chart. I have tried changing the legend, for example,
and cannot seem to make it smaller - font and size - without losing some
data. Any help / suggestions / direction would be greatly appreciated
--
thanks as always for the help
jer

Come back with the SQL view of your chart's Row Source.

--
Duane Hookom
MS Access MVP

"jer" <(E-Mail Removed)> wrote in message
news:E7B9E4B0-9535-4619-9E1E-(E-Mail Removed)...
>I am creating a report from a query. I have asked previously how to show
> months instead of the month number. With a little help from this
> newsgroup,
> that part is fixed. Now I cannot seem to sort the months by month order,
> it
> is only being sorted alphabetically. Is it possible to sort by month
> order
> on the chart.
>
> How can I format the chart. I have tried changing the legend, for
> example,
> and cannot seem to make it smaller - font and size - without losing some
> data. Any help / suggestions / direction would be greatly appreciated
> --
> thanks as always for the help
> jer

as requested ...

SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS [Monthly
Transactions]
FROM [Monthly Volumes]
GROUP BY [Monthly Volumes].Mth
ORDER BY [Monthly Volumes].Mth;

--
thanks as always for the help


"Duane Hookom" wrote:

> Come back with the SQL view of your chart's Row Source.
>
> --
> Duane Hookom
> MS Access MVP
>
> "jer" <(E-Mail Removed)> wrote in message
> news:E7B9E4B0-9535-4619-9E1E-(E-Mail Removed)...
> >I am creating a report from a query. I have asked previously how to show
> > months instead of the month number. With a little help from this
> > newsgroup,
> > that part is fixed. Now I cannot seem to sort the months by month order,
> > it
> > is only being sorted alphabetically. Is it possible to sort by month
> > order
> > on the chart.
> >
> > How can I format the chart. I have tried changing the legend, for
> > example,
> > and cannot seem to make it smaller - font and size - without losing some
> > data. Any help / suggestions / direction would be greatly appreciated
> > --
> > thanks as always for the help
> > jer
>
>
>

Where is your month number? Make sure there is a date or month number in
[Monthly Volumes] and the use it in the ORDER BY rather than Mth which I
assume is text.

--
Duane Hookom
MS Access MVP

"jer" <(E-Mail Removed)> wrote in message
news:49C11B6C-B2FA-409E-9CFE-(E-Mail Removed)...
> as requested ...
>
> SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS [Monthly
> Transactions]
> FROM [Monthly Volumes]
> GROUP BY [Monthly Volumes].Mth
> ORDER BY [Monthly Volumes].Mth;
>
> --
> thanks as always for the help
>
>
> "Duane Hookom" wrote:
>
>> Come back with the SQL view of your chart's Row Source.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>> "jer" <(E-Mail Removed)> wrote in message
>> news:E7B9E4B0-9535-4619-9E1E-(E-Mail Removed)...
>> >I am creating a report from a query. I have asked previously how to
>> >show
>> > months instead of the month number. With a little help from this
>> > newsgroup,
>> > that part is fixed. Now I cannot seem to sort the months by month
>> > order,
>> > it
>> > is only being sorted alphabetically. Is it possible to sort by month
>> > order
>> > on the chart.
>> >
>> > How can I format the chart. I have tried changing the legend, for
>> > example,
>> > and cannot seem to make it smaller - font and size - without losing
>> > some
>> > data. Any help / suggestions / direction would be greatly appreciated
>> > --
>> > thanks as always for the help
>> > jer
>>
>>
>>

Duane, thanks for the quick response, you are right Mth is text. I have a
field VMonth which is the month number. When I ORDER BY VMonth everything is
fine except that the chart shows 1 2 3 ... for the months and not January
February ... The statement using VMonth is below

SELECT [Monthly Volumes].VMonth, Sum([Monthly Volumes].NoOfTxnsl) AS
[Monthly Transactions]
FROM [Monthly Volumes]
GROUP BY [Monthly Volumes].VMonth
ORDER BY [Monthly Volumes].VMonth;

--
thanks as always for the help


"Duane Hookom" wrote:

> Where is your month number? Make sure there is a date or month number in
> [Monthly Volumes] and the use it in the ORDER BY rather than Mth which I
> assume is text.
>
> --
> Duane Hookom
> MS Access MVP
>
> "jer" <(E-Mail Removed)> wrote in message
> news:49C11B6C-B2FA-409E-9CFE-(E-Mail Removed)...
> > as requested ...
> >
> > SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS [Monthly
> > Transactions]
> > FROM [Monthly Volumes]
> > GROUP BY [Monthly Volumes].Mth
> > ORDER BY [Monthly Volumes].Mth;
> >
> > --
> > thanks as always for the help
> >
> >
> > "Duane Hookom" wrote:
> >
> >> Come back with the SQL view of your chart's Row Source.
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >> "jer" <(E-Mail Removed)> wrote in message
> >> news:E7B9E4B0-9535-4619-9E1E-(E-Mail Removed)...
> >> >I am creating a report from a query. I have asked previously how to
> >> >show
> >> > months instead of the month number. With a little help from this
> >> > newsgroup,
> >> > that part is fixed. Now I cannot seem to sort the months by month
> >> > order,
> >> > it
> >> > is only being sorted alphabetically. Is it possible to sort by month
> >> > order
> >> > on the chart.
> >> >
> >> > How can I format the chart. I have tried changing the legend, for
> >> > example,
> >> > and cannot seem to make it smaller - font and size - without losing
> >> > some
> >> > data. Any help / suggestions / direction would be greatly appreciated
> >> > --
> >> > thanks as always for the help
> >> > jer
> >>
> >>
> >>
>
>
>

My suggestion was to use VMonth in the ORDER BY, not in the SELECT
Try this SQL:

SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS
[Monthly Transactions]
FROM [Monthly Volumes]
GROUP BY [Monthly Volumes].Mth
ORDER BY [Monthly Volumes].VMonth;

--
Duane Hookom
MS Access MVP

"jer" <(E-Mail Removed)> wrote in message
news:88A6F7E3-4EC1-49A8-BF96-(E-Mail Removed)...
> Duane, thanks for the quick response, you are right Mth is text. I have
> a
> field VMonth which is the month number. When I ORDER BY VMonth everything
> is
> fine except that the chart shows 1 2 3 ... for the months and not January
> February ... The statement using VMonth is below
>
> SELECT [Monthly Volumes].VMonth, Sum([Monthly Volumes].NoOfTxnsl) AS
> [Monthly Transactions]
> FROM [Monthly Volumes]
> GROUP BY [Monthly Volumes].VMonth
> ORDER BY [Monthly Volumes].VMonth;
>
> --
> thanks as always for the help
>
>
> "Duane Hookom" wrote:
>
>> Where is your month number? Make sure there is a date or month number in
>> [Monthly Volumes] and the use it in the ORDER BY rather than Mth which I
>> assume is text.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>> "jer" <(E-Mail Removed)> wrote in message
>> news:49C11B6C-B2FA-409E-9CFE-(E-Mail Removed)...
>> > as requested ...
>> >
>> > SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS
>> > [Monthly
>> > Transactions]
>> > FROM [Monthly Volumes]
>> > GROUP BY [Monthly Volumes].Mth
>> > ORDER BY [Monthly Volumes].Mth;
>> >
>> > --
>> > thanks as always for the help
>> >
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> Come back with the SQL view of your chart's Row Source.
>> >>
>> >> --
>> >> Duane Hookom
>> >> MS Access MVP
>> >>
>> >> "jer" <(E-Mail Removed)> wrote in message
>> >> news:E7B9E4B0-9535-4619-9E1E-(E-Mail Removed)...
>> >> >I am creating a report from a query. I have asked previously how to
>> >> >show
>> >> > months instead of the month number. With a little help from this
>> >> > newsgroup,
>> >> > that part is fixed. Now I cannot seem to sort the months by month
>> >> > order,
>> >> > it
>> >> > is only being sorted alphabetically. Is it possible to sort by
>> >> > month
>> >> > order
>> >> > on the chart.
>> >> >
>> >> > How can I format the chart. I have tried changing the legend, for
>> >> > example,
>> >> > and cannot seem to make it smaller - font and size - without losing
>> >> > some
>> >> > data. Any help / suggestions / direction would be greatly
>> >> > appreciated
>> >> > --
>> >> > thanks as always for the help
>> >> > jer
>> >>
>> >>
>> >>
>>
>>
>>

Thank you Duane. That's it, perfectly
--
thanks as always for the help


"Duane Hookom" wrote:

> My suggestion was to use VMonth in the ORDER BY, not in the SELECT
> Try this SQL:
>
> SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS
> [Monthly Transactions]
> FROM [Monthly Volumes]
> GROUP BY [Monthly Volumes].Mth
> ORDER BY [Monthly Volumes].VMonth;
>
> --
> Duane Hookom
> MS Access MVP
>
> "jer" <(E-Mail Removed)> wrote in message
> news:88A6F7E3-4EC1-49A8-BF96-(E-Mail Removed)...
> > Duane, thanks for the quick response, you are right Mth is text. I have
> > a
> > field VMonth which is the month number. When I ORDER BY VMonth everything
> > is
> > fine except that the chart shows 1 2 3 ... for the months and not January
> > February ... The statement using VMonth is below
> >
> > SELECT [Monthly Volumes].VMonth, Sum([Monthly Volumes].NoOfTxnsl) AS
> > [Monthly Transactions]
> > FROM [Monthly Volumes]
> > GROUP BY [Monthly Volumes].VMonth
> > ORDER BY [Monthly Volumes].VMonth;
> >
> > --
> > thanks as always for the help
> >
> >
> > "Duane Hookom" wrote:
> >
> >> Where is your month number? Make sure there is a date or month number in
> >> [Monthly Volumes] and the use it in the ORDER BY rather than Mth which I
> >> assume is text.
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >> "jer" <(E-Mail Removed)> wrote in message
> >> news:49C11B6C-B2FA-409E-9CFE-(E-Mail Removed)...
> >> > as requested ...
> >> >
> >> > SELECT [Monthly Volumes].Mth, Sum([Monthly Volumes].NoOfTxnsl) AS
> >> > [Monthly
> >> > Transactions]
> >> > FROM [Monthly Volumes]
> >> > GROUP BY [Monthly Volumes].Mth
> >> > ORDER BY [Monthly Volumes].Mth;
> >> >
> >> > --
> >> > thanks as always for the help
> >> >
> >> >
> >> > "Duane Hookom" wrote:
> >> >
> >> >> Come back with the SQL view of your chart's Row Source.
> >> >>
> >> >> --
> >> >> Duane Hookom
> >> >> MS Access MVP
> >> >>
> >> >> "jer" <(E-Mail Removed)> wrote in message
> >> >> news:E7B9E4B0-9535-4619-9E1E-(E-Mail Removed)...
> >> >> >I am creating a report from a query. I have asked previously how to
> >> >> >show
> >> >> > months instead of the month number. With a little help from this
> >> >> > newsgroup,
> >> >> > that part is fixed. Now I cannot seem to sort the months by month
> >> >> > order,
> >> >> > it
> >> >> > is only being sorted alphabetically. Is it possible to sort by
> >> >> > month
> >> >> > order
> >> >> > on the chart.
> >> >> >
> >> >> > How can I format the chart. I have tried changing the legend, for
> >> >> > example,
> >> >> > and cannot seem to make it smaller - font and size - without losing
> >> >> > some
> >> >> > data. Any help / suggestions / direction would be greatly
> >> >> > appreciated
> >> >> > --
> >> >> > thanks as always for the help
> >> >> > jer
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>