John,
Thanks for your prompt response. Yes the "size" field was set to
text format. As suggested by you, I tried to add another numeric
field for size. But the field is not accepting values like 1/4, 1/2
etc. The error message I get is "The value you entered isn't valid
for this field. You may have entered text in numberic field or the
number you entered is larger than the field size permits". I prefer
to indicate sizes in fraction rather than in decimal form as pipe
sizes are always mentioned in fraction form. Also, the second part of
your solution is not clear to me. Where can I set
property "SortOrder" for the table field and where to mention the
required sort order? Appreciate if you can elaborate.
Regards,
Kumar Iyer
--- In [email protected], "John" <[EMAIL PROTECTED]> wrote:
>
> 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" <access_kri@> 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/
