transaction and account dates out of order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I enter transactions in Acces but in the individual
account the dates are not in order.

This has only just strted to happen.

Can this be fixed please?
 
Where are you looking at them, in a table? If so, there is no guarantee that
the records will be in any particular order in a table. To sort the records,
use a query. You can also have a form or report sort the records that it
displays.

If you do a Compact and Repair, you may get some order back in the table,
but as stated above, there is no guarantee. To do a Compact and Repair go to
Tools|Database Utilities|Compact and Repair Database...
 
Winnie said:
I enter transactions in Acces but in the individual
account the dates are not in order.

This has only just strted to happen.

Can this be fixed please?

Access does not store records in any specific order. If you want
records to display in any specific order you need to tell Access how you
want it sorted.

You can sort on any field or even more than one field. So if you have
an field (IAD) and if that date is a real data type field and not text, just
sort on that field in a query, report or form and the records will appear in
that order. You can further sort records from the same date by maybe the
name of the individual.
 
Back
Top