Sort Sub Form in Descending Date Order

Sort Sub Form in Descending Date Order

Postby Dalkeith » Wed Aug 24, 2016 6:09 pm

Usually to sort a Form in a particular order you go to the forms section and within the SQL write a statement showing the information in descending order.

I have a subform however and the subform does not appear in the forms section.
Fine I can go into objects and select the subform here and I note that there is a tab called display and on selection it has a SQL box.

I am wondering whether I have to define the SQL in a specific way so it that it not only arranges the sub records in a descending date field order but also filters out only children of the parent form.

Could someone who know more maybe give some air code or give some guidance?

Many Thanks

Mark
Dalkeith
 
Posts: 25
Joined: Thu Jun 23, 2016 6:03 pm
Location: Edinburgh

Re: Sort Sub Form in Descending Date Order

Postby Dalkeith » Wed Aug 24, 2016 6:13 pm

My first thought was I just completely omit the select section of of the SQL and simply place in Order by clause

Code: Select all
ORDER BY DATEUPDATED DESC


That didn't seem to work
Dalkeith
 
Posts: 25
Joined: Thu Jun 23, 2016 6:03 pm
Location: Edinburgh

Re: Sort Sub Form in Descending Date Order

Postby Dalkeith » Wed Aug 24, 2016 6:20 pm

Apologies discovered how to do it.

Access Sub Form via Objects button.

Go to Subform tab and here you will see the entire SQL already defined.

Alter the SQL as required.

Thanks everyone for brilliant and easy product
Dalkeith
 
Posts: 25
Joined: Thu Jun 23, 2016 6:03 pm
Location: Edinburgh

Re: Sort Sub Form in Descending Date Order

Postby admin » Tue Aug 30, 2016 8:45 am

Cool!
admin
Site Admin
 
Posts: 3348
Joined: Mon Jun 15, 2009 9:53 am


Return to General



cron