how do I insert a row alphabetically

[Guest]

how do I insert a row alphabetically, in 2003 it was easy, In 2007 I can't
find how, when I attempt it, it puts the new at the bottom

 

[RoyVidar]

how do I insert a row alphabetically, in 2003 it was easy, In 2007 I
can't find how, when I attempt it, it puts the new at the bottom

I don't think you can insert anything alphabetically, as that is
kind of contrary to both database theory, and most implementations
of relational databases - and as far as I know, also for Access/Jet.

What one would usually do, not that I know anything about the
2007 version, is to use a query to sort the information by the
column you wish. In addition to using a query, both forms and
reports have some additional methods for sorting.

Perhaps, if you explain a bit more how/what you're doing, someone
can assist better.

 

[Joseph Meehan]

how do I insert a row alphabetically, in 2003 it was easy, In 2007 I
can't find how, when I attempt it, it puts the new at the bottom

No it was not only not easy in 2003 it was impossible. Access tables do
not store data in any specific order.

What you likely did in Access 2003 was to provide some sort of order via
a query, form or report. You should be able to do the same in 2007, but I
have not seen it yet.

 

[Guest]

Hi Roy
Many thanks, sorry to waste your time, I've been using Excel 2003 on my
laptop not having Access on that M/c to produce a database and with that
programme you can insert rows alaphabeticaly. I assumed I could do the same
in Access

 

[Guest]

Hi Joseph
Many thanks, sorry to waste your time, I've been using Excel 2003 on my
laptop not having Access on that M/c, to produce a database and with that
programme you can insert rows alaphabeticaly. I assumed I could do the same
in Access