sorting and grouping

[hj]

Hi Bonnie,
Assuming you have a "week" field to group and sort on,
you should be able to add the "date" field to the sorting
and grouping set in report design. Sorting and grouping
in a report will overide sorting in a source query.
If this doesn't work, I think you'll need to supply
more info about the data coming out of the query.

Hopr this helps.

-----Original Message-----
I have created a query of courses with start dates and

then created a report based on that query. I now want to
sort the report by start dates and group those start dates
by weeks. When I went into sorting and grouping to do
this, it gave me the grouping by weeks but the dates were
no longer sorted. When I take off the grouping, the dates
are now sorted. I did take off the sort information in the
query and thought that would help, but it does not. Please
help.

 

[Van T. Dinh]

F.Y.I.: the Report ignore the ordering in the Query so
don't worry about the ORDER BY clause in the Query. It
will only use its own sorting and Grouping.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I discovered that if I group the "start date" field and

then go back in and sort the "start date" field, it works.
I appreciate your help.