chart question??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Come back with the SQL view of your chart's Row Source.
Click to expand...
 
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 said:
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;
Click to expand...
 
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 said:
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 said:
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 said:
Come back with the SQL view of your chart's Row Source.

--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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


:

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

--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
Thank you Duane. That's it, perfectly
--
thanks as always for the help


Duane Hookom said:
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 said:
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 said:
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

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


:

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

--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top