Months disorder

[M.A.Halim]

Dear Group
I have a sales report that displays the monthly sales and number of
customers for every month. in the underlying query I have a [monthnumber]
field to control the month order so that Jan will come first and Dec will
come at the end of the report Sorted ascending.
in the report I have the months sequence come correct until I add a new text
box in the report footer that calculates the avg([Sales]) or Avg([Customer])
and so on, then the months order comes mixed I find April comes on top and
Jan comes second last and so on..
is there any reason for that and how can I over come this issue?
Thanks A lot

 

[Steve]

In a report, you need to sort in the report. The sort order in a report
overrides any sort order in the underlying query.

Steve
(e-mail address removed)

 

[Nick Coe \(UK\)]

As Steve said, any sort order you have set in the report
will override anything in the query. You can run into
similar snags with Grouping so I don't bother to order in a
query used as the source for a report; but rather use the
reports 'Order By' property or a given section's Sorting and
Grouping depending upon what I'm trying to achieve.

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In M.A.Halim typed:

 

[M.A.Halim]

Thanks A lot, i missed that point, i thought order is based on the query not
the report itself.
--
M.A.Halim
mmhalim at hot mail dot com

As Steve said, any sort order you have set in the report
will override anything in the query. You can run into
similar snags with Grouping so I don't bother to order in a
query used as the source for a report; but rather use the
reports 'Order By' property or a given section's Sorting and
Grouping depending upon what I'm trying to achieve.

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In M.A.Halim typed:

Dear Group
I have a sales report that displays the monthly sales and
number of customers for every month. in the underlying
query I
have a [monthnumber] field to control the month order so
that
Jan will come first and Dec will come at the end of the
report
Sorted ascending.
in the report I have the months sequence come correct
until I
add a new text box in the report footer that calculates
the
avg([Sales]) or Avg([Customer]) and so on, then the months
order comes mixed I find April comes on top and Jan comes
second last and so on..
is there any reason for that and how can I over come this
issue?
Thanks A lot

.