Returning records sequentially

[Lamb2087]

I have a query that returns all the records sequentially some what. It will list the records like 1, 10 1000, 1001
It will jump like 1200, 12, 1201, 1202

instead of 1,2,3,4,5,6,7,8,9,10

It will list 1, 10, 1000

Any ideas?

Here is the query to list all records. I have gon intot he report for sorting and that did not make it work either.

SELECT dbo_INV_INFSVC.CS_NUM, dbo_INV_INFSVC.NON_TECH_DES, dbo_INV_INFSVC.USER_OPR, dbo_INV_INFSVC.SERIAL_NUM, dbo_INV_INFSVC.NMMI_NUM, dbo_INV_INFSVC.ROOM_NUM, dbo_INV_INFSVC.BUILDING, dbo_INV_INFSVC.LOCATION, dbo_INV_INFSVC.CHECKED, dbo_INV_INFSVC.DEPARTMENT
FROM dbo_INV_INFSVC;

 

[Travis]

What is the Fields Data Type? (It looks to me like it is a String/Text field in the table).

If that is the case change the query slightly:

SELECT dbo_INV_INFSVC.CS_NUM, dbo_INV_INFSVC.NON_TECH_DES, dbo_INV_INFSVC.USER_OPR, dbo_INV_INFSVC.SERIAL_NUM, dbo_INV_INFSVC.NMMI_NUM, dbo_INV_INFSVC.ROOM_NUM, dbo_INV_INFSVC.BUILDING, dbo_INV_INFSVC.LOCATION, dbo_INV_INFSVC.CHECKED, dbo_INV_INFSVC.DEPARTMENT ,Format([dbo_INV_INFSVC.CS_NUM],'0000000000') as MYSORT
FROM dbo_INV_INFSVC;

Then use the "MYSORT" field as your reports Sort Criteria

 

[Lamb2087]

Thank you! What you sent worked and I appreciate the help.

Thanks Again!!