Have the following form and results of this search are displayed on another page:

<FORM ACTION="FMPro" METHOD="POST">

<INPUT TYPE="hidden" NAME="-db" VALUE="TASKLOG.fp5">

<INPUT TYPE="hidden" NAME="-format" VALUE="openresults.htm">

<INPUT TYPE="hidden" NAME="-SortField" VALUE="Date In">

<INPUT TYPE="hidden" NAME="-SortOrder" VALUE="Descending">

<INPUT TYPE="hidden" NAME="-Max" VALUE="all">

<INPUT TYPE="hidden" NAME="-token" VALUE="[FMP-CurrentToken]">

<INPUT TYPE="hidden" NAME="-token.1" VALUE="[FMP-CurrentToken:1]">

Currently the results are sorted by 'Date In' but I would like them to be sorted by 'Time In' as well.

I have tried adding <INPUT TYPE="hidden" NAME="-SortField" VALUE="Time In"> to the form as well, but it only displays the results in 'Time In' order and ignores the 'Date In'.

Does anyone know how to sort by two fields please?

Many thanks

You should be able to do that simply addding the sort field/order after the first one:

INPUT TYPE="hidden" NAME="-SortField" VALUE="Date In">

<INPUT TYPE="hidden" NAME="-SortOrder" VALUE="Descending">

INPUT TYPE="hidden" NAME="-SortField" VALUE="Time In">

<INPUT TYPE="hidden" NAME="-SortOrder" VALUE="Descending">

Records should be sorted according to the chosen sequence of fields/orders