[RESOLVED] Data out of order - CRXI

[SparrowHawk7]

I'm new to CRXI but have an odd thing happening. I created a new report to link to an mdb file and table. There are 36 records in the table with an autonumbered primary key. For some reason, the preview of the report begins at record 16, goes to 36 and then wraps back around from 1-15. I've created the report several times with the same result. I compacted and repaired the db in Access 2003, but nothing sets the first record to 1 - it's always 16. The data was entered incrementally in order from 1-36 incidentally. Refresh on the report does nothing. All reports based on this particular table behave the same although all reports on other tables are fine. Any thoughts?

TIA,
Ken

[rasinc]

I would go to the Report, Record Sort Expert and force the sorting. Never leave it up to the database. It will give you the information in the order it finds it if you don't force the sort yourself.

[SparrowHawk7]

Thanks rasinc. That did it ... sorry it took me a few days to get back. I'll have to remember that even though I've been lucky with all my other reports.

[rasinc]

Glad to hear it helped. It sounds redundant and it take a little extra time but it is well worth getting expected results consistantly. I've done a few reports where the entry order is required but it is always the last sort after all the groupings and each time I activate it, I always see changes in the order of the data so the data will not always follow the rules within the database when doing external reporting.