Home ms Access '16 - Continuous form - OrderBy textbox value created with expression
 I have a form that shows the records from Table-A, it is a continuous form. I have a textbox that uses a DCount expression to count records from Table-B that share the same SOP-Number. =DCount("*","[Table-B]","SOP = " & [SOP])  This works but I don't know how I would go about sorting that column based of the resulting values. The other columns are sorted thus: " ORDER BY [FIELD NAME] ASC;"  So without a field I don't know how (or if) I can sort the form. Could I create a RecordSet to store the values then sort by that field (I don't know if this is even possible) Thank you Dan Access 2016 (365)