Form not reflecting Query's sort order

[ctpoodle]

Hi there. I have a form built on a query that has a 2-level sort, ascending on one field (numeric) and descending on another field (numeric). My expectation was that the form would show the data in the order of the query's sorting, but it does not appear to be doing that consistently. Any thoughts off the top of anyone's head?

Thank you!

 

[ctpoodle]

Okay, problem is resolved.

 

[bob fitz]

Can you share the secret of your success.

 

[ctpoodle]

After tearing my hair out looking at the underlying query, the table structure, and the form, and testing and retesting - in my development database - I found the inconsistency in the user data. SMH. I'm going to have to write something to normalize certain data once it gets to the database (it comes from an external source.) :banghead: