I am trying to sort an Access 2007 table that I created, first by the Primary
Key Field and then by the Date Field. and I really do not feel like creating
a query, so how can I go about doing that?
--
SDA

Sierre Demonte Aires wrote:
> I am trying to sort an Access 2007 table that I created, first by the
> Primary Key Field and then by the Date Field. and I really do not
> feel like creating a query, so how can I go about doing that?

Tables cannot be sorted. Period.

When you view a table's datasheet Access is producing something visual for
you to see the data. The data viewed in that "thing" can be sorted and it
can be fiddled with as far as moving columns around, changing column widths,
etc., but none of that affects the actual table under the covers. None of
it affects how the table's data is reflected in forms, reports, queries, or
code.

SELECT *
FROM TableName
ORDER BY ThisField, ThatField


The query above would take all of 10 seconds to produce. What is your
objection to doing so?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Sun, 9 Nov 2008 06:25:00 -0800, Sierre Demonte Aires
<(E-Mail Removed)> wrote:

>I am trying to sort an Access 2007 table that I created, first by the Primary
>Key Field and then by the Date Field. and I really do not feel like creating
>a query, so how can I go about doing that?

You don't.

Tables are for storing data.

Queries are for selecting, combining and sorting data.

Forms are for displaying data onscreen.

Reports are for printing.


Use the correct tool for the job you're trying to do.
--

John W. Vinson [MVP]

One other thing.

If you have sorted by the primary key, then there is no other sort to do.
Primary key is unique and therefore sorting by the primary key is going to
produce a unique order so any subsequent fields involved in the sort will have
NO impact.

If you want to sort by the date field and then by the primary key field then
you will have a different sort.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

John W. Vinson wrote:
> On Sun, 9 Nov 2008 06:25:00 -0800, Sierre Demonte Aires
> <(E-Mail Removed)> wrote:
>
>> I am trying to sort an Access 2007 table that I created, first by the Primary
>> Key Field and then by the Date Field. and I really do not feel like creating
>> a query, so how can I go about doing that?
>
> You don't.
>
> Tables are for storing data.
>
> Queries are for selecting, combining and sorting data.
>
> Forms are for displaying data onscreen.
>
> Reports are for printing.
>
>
> Use the correct tool for the job you're trying to do.