when i add a new record in atable, it gets added ramdomly.

[arunsule]

new records in a table get added randomly.
and the query based on this table does not work properly as
it never reads the last record correctly
what to do so that the records get added on first come basis?

 

[iainm]

Add a field to your table called "Record Number" and make its datatype AutoNumber. That way, each new record which is added to the database gets its own unique identifier. If you then sort on this field, they will be in the order you added them.

 

[arunsule]

dear iainm
thank you for your immediate response.
i have already done this.
i added a field "sl no', with its datatype auto no.
and kept index on
this way the records are displayed in order but still the query does not refer to the indexed table .
can i email the table to you?
regards
arunsule

 

[iainm]

sure.
tgml@spudpages.com

 

[Steve101]

Arunsule,

In the query that you have defined, make sure that you sort the query by the Autonumber field that you have added to the table; ie. ensure that this field is included in the query, and select the "Ascending" option from the pulldown list of that column in the Sort: row of the query grid.

At the moment it sounds like you are not providing any sorting criteria associated with the query.

Cheers,
Steve.

 

[B827]

This is the same as

thread700-243491

can you post only once as you now have two offers to look at the tables. One should be enough. Sandy