Sort report by dates hire, days request.

[scopes456]

i would like to have a report that i would like to perform two sorts , to arrange employee names. One i would like it to look at how many request they made (requestmade), and then it will look at their date of hire(DOH) to list their names from first to last. I have a query that delieves all the information i need to the report, but i cannot organize the report to perform this action. Please help.

 

[pbaldy]

Sorting in the report is set in Grouping and Sorting. If it doesn't show at the bottom in design view, there's an icon on the ribbon to put it there.

 

[scopes456]

pbaldy I did try that at the bottom at the report, but when it came for the date, it does not sort it properly. For example it will list it ,
7/5/2007,7/17/1997,7/11/2011.

When i would like it to be listed, 7/17/1997,7/5/2007,7/11/2011.

thanks for your help.

 

[pbaldy]

Sounds like your field is text rather than date/time, which gives you an alphabetical sort.

 

[arnelgp]

try sorting on "expression", like:

=[yourEmployeeFieldName] & Format([RequestMade],"#####") & Format([DOH],"yyyymmdd")

 

[scopes456]

pbaldy and arnelgp thank you for your help, and the field was text instead of date/time

 

[pbaldy]

No problem.