Report Grouping & Sorting

  • Thread starter Thread starter ARS
  • Start date Start date
A

ARS

I have a field "Year" whose values are derived from a date as
format(lastdate, "yyyy/mm") as [year].

I am trying to sort on the "yyyy/mmm" and group on "yyyy" so that the first
page of the report will look like:

1999/01 ....
1999/02 ....
 
Write a query that parses your date field into two fields and you should
have no problem grouping and sorting.
 
Back
Top