Sort by date

S

StuJol

i have a report which gets it data from a qry. In the qry the dates are
sorted like
01/01/2006
17/01/2006
29/01/2006
04/02/2006 etc etc

In my report the dates are displayed in reverse order

04/02/2006
29/01/2006
17/01/2006
01/01/2006

Is there any way to display these dates in the reverse order, like the qry
 
R

Rick B

In your grouping and sorting dialog box for your report, just change the
sort to ascending.
 
M

Marshall Barton

StuJol said:
i have a report which gets it data from a qry. In the qry the dates are
sorted like
01/01/2006
17/01/2006
29/01/2006
04/02/2006 etc etc

In my report the dates are displayed in reverse order

04/02/2006
29/01/2006
17/01/2006
01/01/2006

Is there any way to display these dates in the reverse order, like the qry

Sorting in a report's record source query is a waste of
time. Report sorting is specified in the Sorting and
Grouping window (View menu).
 

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

Top