Since we have no way of knowing a) the structure of your tables, b)
the SQL of your queries, c) the structure of your forms, and d) where
you're "looking at the accounts" it's hard to be very helpful.

I can say that if you're looking at Tables, the order of records is
arbitrary (you'll usually see them in primary key order but even that
depends on how you're looking).

If you want to see records in any particular order, then you must use
either a Query sorting by the desired fields, or a Form or Report with
its Order By property set.

                 John W. Vinson[MVP]