Hi,

I am a newbie to the forum and a relatively new Access user.

I have a database made up of three related tables, 2 have a one to many relationship with the largest table (which consists of only 139 records) and a number of forms and reports.

I am experiencing an odd problem where the forms and reports are listing records 31 - 39 at the end of the sequence after record 139. All other records are listing correctly. I have checked the 'order by' property for the forms and tables but cannot find anything out of place.

Can anyone suggest anything I may have missed?

Thanks in advance

Jon

Welcome to the Forum,

Sorting by numbers sometimes does cause issues, have you created the report based on a query or direct from the table?

If from a query you can check the source and apply a sort there to see if the query runs correctly then it should appear correct in the Report.

Hi,

Thank you for the welcome.

Running a new form from a query seems to have fixed this. Is it generally advisable not to run queries or reports straight from tables?

Many thanks

Jon

That depends Jon,

I would prefer to use queries to run the reports and forms as this then becomes a practice which works for me, sometimes though they will increase the size of the database which then has to be compacted regularly.

As long as it is now working in the way you want then that is successful.

Trevor,

Many thanks for your help and advice.

Jon