Report

  • Thread starter Thread starter Mr K
  • Start date Start date
M

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
 
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.
 
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.
 
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
 
Mr K said:
You can say "None" to the sorting question and you get
just what you ask for in the order it is in the table.
Click to expand...

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?
 
Back
Top