sort by date in report

G

Guest

Hi,

I have a report based on a query. The [Date] field in my report and query
is sorted in "ascending" order.

Problem: In actual report, the dates are not quite sorted.

ex) Order in which dates appear:

5/7/05
6/8/05
8/24/05
2/3/05
2/25/06

I suspect this has something to do with the way my fields are grouped.
Right now, I have one main field, under which everything else is grouped
(including [Date]). Does [Date] have to be its own subgroup in order to
maintain order? I hope not, because I do not want to group by date at all.
I just want to list dates within a group in ascending order. Does anyone
know what the problem might be?

Thanks,
Diana
 
D

Douglas J. Steele

The only way to control the sorting in a report is through the Sorting and
Grouping dialog, but adding a field there doesn't force you to group on it:
you simply set the Group Header and Group Footer properties to No.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort order in report 2
Report sorting function 2
sort alphabetical in report 4
Date/Text field in Report 7
Put report in Ascending order of date 1
sorting function yields unwanted results 6
Grouping in a Report 4
Date Period: Format([Call date],"mmm yy") - Sort Date 5

Top