Asp - Display data by date
<p>Is it possible to display this data in order of LastActivityDate</p>

<pre><code>&lt;asp:AccessDataSource ID="usage_info_DS" runat="server" DataFile="~/App_Data/ASPNetDB.mdb" SelectCommand="SELECT aspnet_Users.UserName, aspnet_Users.LastActivityDate, aspnet_Membership.LastLoginDate FROM (aspnet_Membership INNER JOIN aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId) WHERE (aspnet_Membership.UserId &lt;&gt; 100) AND (aspnet_Membership.UserId IN (SELECT UserId FROM aspnet_UsersInRoles WHERE (RoleId = (SELECT RoleId FROM aspnet_Roles WHERE (RoleName = ?)))))"&gt;
        &lt;SelectParameters&gt;
            &lt;asp:ControlParameter ControlID="DropDownList1" Name="?" PropertyName="SelectedValue" /&gt;
        &lt;/SelectParameters&gt;
    &lt;/asp:AccessDataSource&gt;
</code></pre>

<p>Cheers
Ross</p>
