Sorting?

  • Thread starter Thread starter stefan
  • Start date Start date
S

stefan

I have a table includes ProductID (autonumber), Product
Number and ProductName. IN the table all data is ordered
numerically by the Product Number. However, when viewing
Product details on a form based on this table, the
products are sorted as 1,10,11,12....2,20,21...3,30,31
etc.
How can I remedy this problem and view product details in
the correct numerical order ie. 1,2,3 etc.
thanks
 
I assume Product Number is text. You can try create a calculated column in
your form's record source query
SortProdNum: Val([Product Number])
 
I have a table includes ProductID (autonumber), Product
Number and ProductName. IN the table all data is ordered
numerically by the Product Number. However, when viewing
Product details on a form based on this table, the
products are sorted as 1,10,11,12....2,20,21...3,30,31
etc.
How can I remedy this problem and view product details in
the correct numerical order ie. 1,2,3 etc.
thanks
Click to expand...

It sounds like the Product Number is a Text field rather than a
number. Either use a Number datatype or sort by Val([Product Number]).
 
Back
Top