Report

[Mr K]

Hi,

Using XP, Office XP and Access 2000.

I have a simple DB:
Date, data.data... etc (7 data elements)

In Table the sort is correct by date, Jan.
In Query the sort is correct by date, Jan.
In Forms the sort is correct by date, Jan.
In Reorts the Sort starts with Apr.

How do I set up for no sorting at all, but especially in
Report?

Thank you,

Mr K

 

[Allen Browne]

If you want the report sorted in a particular order (by date?), you must
specify the date field in the Sorting And Grouping dialog for the report.

This will need to be a date field: sorting by the month name would bring up
the month starting with A first.

 

[Mr K]

I don't want want to sort, nada, none, nothing sort.
How do I dis able sorting!!!!!!!

Mr K

 

[Allen Browne]

If you do not specify a sort order, Access can do anything it wants and be
correct. That is what you are getting now: no defined sort order = you do
not care how Access presents the data.

In relational database theory, you can think of the table as being a bucket.
You throw records in, and ask Access to pull them out. Unless you specify an
order, you just take what you get. Further, that order can change to
something different (and may very well do so, e.g. after a compact.)

"Unsorted in a particular order" is a contradiction.

 

[Mr K]

Your the expert, but I fixed it.
You can say "None" to the sorting question and you get
just what you ask for in the order it is in the table.

Mr K

 

[Allen Browne]

You can say "None" to the sorting question and you get
just what you ask for in the order it is in the table.

But do you? Or is that just what you see today? Will it be the same later?
After a compact? After a rebuild? When Access no longer knows what order the
records were added?