getting dates in order

[Guest]

Hope this makes sense

Using the generic ledger database in access 2000
I enter a transaction and dates are in ascending order
When looking at the individual accounts the transactions are not in order.

Help please

 

[John Vinson]

Hope this makes sense

Using the generic ledger database in access 2000
I enter a transaction and dates are in ascending order
When looking at the individual accounts the transactions are not in order.

Help please

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]