WHY DON'T MY INVOICES APPEAR ON TABLES IN THE ORDER KEYED?

C

crackertown

When I key invoices in ACCESS Forms, they do not appear in tables in the
order keyed after I updated to WINDOWS XP. It is helpful to me that they
appear in tables in the order keyed. Many are duplicate and I can copy in
the tables faster than re-keying them. Now, the invoices are scattered
out all over the table and make it much harder to locate a certain group of
invoices if I need too.
 
R

Rick B

As posted all the time in this group, records are not stored in any
particular order. If you want them ordered, then you need to sort them
based on something. You might have a timestamp field where you store the
current date and time when a record is added.

In short, you should not really care what order they were entered.


Rick B
 
F

fredg

When I key invoices in ACCESS Forms, they do not appear in tables in the
order keyed after I updated to WINDOWS XP. It is helpful to me that they
appear in tables in the order keyed. Many are duplicate and I can copy in
the tables faster than re-keying them. Now, the invoices are scattered
out all over the table and make it much harder to locate a certain group of
invoices if I need too.
Click to expand...

Why are you even looking at the tables?
Tables are for storing data, not for viewing.

Records in Access are not stored in any particular order.
If you must see the records in a particular order, create a form,
using a query sorted on a Date/Time field (which you have added to
your table) as record source. Then the records will display in the
form in the order you entered them.
 
Top