Home ms Access '16 - Continuous form - OrderBy textbox value created with expression
Reply: 0

ms Access '16 - Continuous form - OrderBy textbox value created with expression

user750
1#
user750 Published in April 20, 2018, 10:51 am

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)
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.380571 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO