Adding records

[Randi Cox]

I have a database set up for county bridge inspections. I
recently added a few new bridges (records) to the
database, which consists of two tables. The bridge number
is the primary key. I added these after the last record,
and the next time I opened up the tables, they were
automatically sorted into both tables in numerical order
(which is what I want). The strange thing, however, is
that when I run a query to check specific information on
the bridges, all the bridges listed in the result are in
numerical order, but those newly added bridges are at the
end (sorted themselves as a little group). When I run a
query simply combining the two tables, it is in proper
numerical order. It is only when I specify criteria that
it groups the new bridges separately at the bottom. Any
ideas?
Thanks,
Randi K. Cox

 

[Rebecca Riordan]

Randi,

Conceptually, records in a table have no order -- think of the table as a
brown paper bag and the records as little slips of paper. If you don't
specify a sort order, the records will be in any old order that Access
decides to use, and it won't necessarily be the same all the time.

My advice to you would be not to worry about it, just specify a sort order.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...