Sorry for the easy question but I can seem to figure this out. I have set up a room table numbered numericaly. I have it sorted numericaly. It pulls to the query fine but when it goes to the report one room is out of order. I checked the numbers and they are right. Any ideas :confused:

Sorry for the easy question but I can seem to figure this out. I have set up a room table numbered numericaly. I have it sorted numericaly. It pulls to the query fine but when it goes to the report one room is out of order. I checked the numbers and they are right. Any ideas :confused:

Whats the record source for the report? Bind the report to a query that is sorted by the number you want and problem should be solved, if you're already doing that then check the report detail to make sure it isn't grouping by some other field.

The report is bound to a query. All the fields are coming in right but this one. For example we have rooms that go like this D 25-T, D 26-T, A 3-T, A 3-b and so on. I have it set up to keep all the rooms together so all the D rooms are together so all the D rooms stay together and all the A rooms stay together. All of them work except this one room. When I run the query it shows it in the right spot but not in the report.

Check the Sorting and Grouping options on your report, if the data is showing up correctly in your query, then your report may be doing an additional sort that is causing the undesired effect.