Access is sorting correctly since you are using a text field to store the size in text format. The easiest way to sort it in numerical order is to add another numeric field to table PipeDimension (ie. SortOrder) set order numbers the way you need and sort on that field, ie ORDER BY SortOrder.
For example: ==================== PipeSch SortOrder ==================== 1/2 1 1 2 1-1/4 3 1-1/2 4 2 5 etc ... Hope that sort it out for you. --- In [email protected], "access_kri" <[EMAIL PROTECTED]> wrote: > > Dear All, > I have designed a database for displaying values from > standard Engineering Table. The form has a cascading combobox which > the users have to select. The values of other fields are displayed > based on engineering tables. > > The data in the unbound combobox0 & 2 comes from the > following > Combo0 Row Source Property: SELECT DISTINCT [qryPipeDimension]. [Size] > FROM qryPipeDimension; and > > Combo2: SELECT DISTINCTROW [qryPipeDimension].[PipeSch] FROM > qryPipeDimension WHERE ([qryPipeDimension].[Size]=[Forms]! > [frmPipeDimension]![Combo0]) ORDER BY [PipeSch]; > > The values in Combo0 representing pipe size in inches is not > displayed in proper order. It is displayed as 1, 1/2, 10, 1-1/2, 1- > 1/4, 12, 14, 16, 2, 20 and so on. I want the pipe sizes to be > arranged in increasing order such as 1/2, 1, 1-1/4, 1-1/2, 2, 10, 14, > 16 and so on. > > Similarly, the combo2 values are displayed as 10, 10s, 160, 40 > and so on whereas it should be ordered 10, 10s, 40, 40s and so on. > > I would appreciate if the group can help me to order the > values of combo boxes as required. Is custom ordering possible. > > Thanks, > > Kumar Iyer, > Qatar > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
