Wade wrote:
how to fix this?
Date Raceway DO Temp Mort
01/01/04 1 10 15 0
01/02/04 1 10 15 0
01/02/04 2 10 15 1
01/01/04 2 10 15 4
01/01/04 3 10 15 5
When I enter my data the dates and racceways are in order. The same
datefor 5 raceways per day. However the table is jumbling the info.
The dates are no longer in order and morts range from 0 to 5 for some
reason. The dates should be in order as I input them and there is no
order for morts as each raceway varies.
What is wrong????
Although Pieter's advice about using a query is excellent, here's what
I suggest. Use a Make Table query using all the fields to put the
records in the order you want. Use Sort Ascending on, say, Date then
Raceway. After making the table, change the name of the Date field to
RaceDate (Date is a reserved name) in table design mode. Create an
autonumber primary key on the new table such as RaceID and save the
design. After checking to make sure your data is all there delete the
original table. Then rename the new table. After doing this Access
will continue to display the table data in the order you input data.
After doing all that, use a query to guarantee that you get the order
you want for Reports and such.
James A. Fortune