Column fields are mixed up

[gregs]

I have an Access 2000 database that when I create a
report, the first colume has the fields mixed up. For
whatever reason the program is taking the bottom four
fields of the first column and moving them to the top of
the list and pushing the beginning 10 fields down. The
remaining three columns are fine. This happens once in a
great while and I am unable to reproduce the error using
any specific commands. When the error does occur, it
causes a lot of wasted time and money. Any ideas?

 

[Allen Browne]

To define the order of the records in your report, open it in design view.
Choose Sorting And Grouping (View menu).
Specify the field that you wish to sort by.

If you do not specify a sort order, it is undefined and may change randomly.