Sorting

[BLD21]

I have a table below, I want to be able to sort by item field but when I do the QUANTITY_UM field will update to show Case first, then Each, Pallet.

I need for it to remain the same order and just have the records sorted by item name.

Any ideas?

ITEM	LENGTH	WIDTH	HEIGHT	WEIGHT	QUANTITY_UM	CONVERSION_QTY
AP9816	12.50	2.00	2.00	0.17	Each	1.00
AP9816	14.00	13.70	10.10	4.30	Case	25.00
AP9816	48.00	40.00	45.40	182.60	Pallet	800.00

[alansidman]

In a query, add a field with the following Expression. SortOrder: IIF(Quantity_UM="Each",1,IIF(Quantity_UM="Case",2, 3). Hide this field by unchecking the box below the criteria. Now set the sort order to Item and then SortOrder.

Alan

[June7]

Do you have the Quantity_UM field in table set as Index Yes?

[BLD21]

Alan,

Doesn't seem to be working, I must be missing something.


Expr1: [ IIF(Quantity_UM="Each",1,IIF(Quantity_UM="Case",2, 3)]
sort ascending

This is asking for a parameter value

[BLD21]

Alan,

Got it. Was missing a right ending ).

Thanks!