controlling record order

[lshippee]

I have a report that shows data from a survey across multiple years.&nbsp;&nbsp;One of the bound controls is a survey date field which is placed in the details section.&nbsp;&nbsp;The report is also grouped by another category of information.&nbsp;&nbsp;I would like the data to show up consistently in the same year order<br><br>e.g. <br>Survey date = 1999<br>Survey date = 2000<br>. . . in that order for each record.&nbsp;&nbsp;Instead, some records have year 2000 first and some have year 1999 first -- this is a little tedious for the reader -- what suggestions does anyone have?<br>

 

[LarryDeLaruelle]

What you might try is putting an expression in your underlying query to capture the year portion of the date:<br><br>Year: DatePart(&quot;yyyy&quot;,SurveyDate)<br><br>In the report itself, use Sorting/Grouping and set a group control on the Year field; you can either use or not use a group header/footer depending on how you want the info displayed.<br><br>Hope this helps. <p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br>

 

[lshippee]

Thanks for your reply -- actually, I did go to the report and saw that the date field was not included in the sorting/grouping.&nbsp;&nbsp;When I added it, that took care of the problem.