I have a database that stores data about different kits that I build. The data structure is
Field Name Data Type Explanation of what is stored in the field ID AutoNumber Key Kit Short Text Kit Name PartNo Short Text Manufacturer Part Number Man_Id Number Manufacturer ID Number Book_lid Number Book ID where Instructions and key information are kept Pg Number Page number where Instructions are Qty Number Quantity of the kit Dr Number What Drawer Kit is stored Sl Number What Slot in Drawer where kit it stored Finish Short Text What type of finish has been applied to kit UpperDrill Short Text Drill bit size for main LowerDrill Short Text Drill bit size if there are two drills needed Bushings Short Text ID of the bushings I will use to work on the kit Tubes Short Text Size of tubes (if needed) for kit
I am building a report where I want to sort all the kits by the Drawer and Slot where they are stored
The report is built with a sort (ascending) on drawer and then a sort (ascending) on Slot.
When I view the report, the drawer sort comes out as
Drawer Slot 1 1 1 2 1 3 1 4 1 5 10 1 10 2 10 3 10 4 10 5 11 1 11 2 11 3 11 4 11 5 2 1 2 2 2 3 2 4 2 5
I want it to sort the drawer number correctly: 1,2,3,4,5,6,7,8,9,10,11, etc.. then sort the slot the same way
I know this is not a major type problem, but it is an annoyance when I need the report
I have tried both storing the drawer number as text or as a number
I have looked around in this forum as well as the internet in general, but I have not found a way to fix this problem.
What am I not doing that I should be doing