In two reports want the data sorted by date in ascending order

am attaching database-
in rpt1 and rpt2 you will notice - the dates are not displaying in order-
Can I display the dates in ascending order without changing other groupings
thank you
Example1b.accdb
davetoughAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Gustav BrockConnect With a Mentor CIOCommented:
If this is A2013, in designview click Grouping and Sorting on the band.
At the bottom, click Add a sorting, select TDate. It should by default select "from oldest to newest".

See the attachment. (Right-click the link, select "Save as", and - before saving - change the file extension to .accdb).

/gustav
Example1b.accdb
0
 
FlysterConnect With a Mentor Commented:
Your attachment didn't come through as a DB. Open your report in design view and right-click in the detail section. Select Sorting and Grouping. At the bottom of the report select Add Sorting. Add the field that contains your date field.

Flyster
0
 
davetoughAuthor Commented:
Thank you - very Helpful-
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
All Courses

From novice to tech pro — start learning today.