Custom sort order

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

Hi guys,
I am using the following custom sort order :

Expr1: Switch([Accomodation - Unit]="object","a",[Accomodation - Unit]="
object","b",[Accomodation - Unit]=" object","c",[Accomodation - Unit]="
object","d",[Accomodation - Unit]=" object","e",[Accomodation - Unit]="
object","f",[Accomodation - Unit]=" object","g",[Accomodation - Unit]="
object","h",[Accomodation - Unit]=" object","i")



this works fine but when i increase the number of objects past 14 i get an
error say that the expression is too complex.



any ideas?



cheers
 
Create a table to hold all the various type of accomodation you need to
handle.

Add a field to that table that contains the "a", "b", etc.

Include that table in a query along with your main table.
Sort the query on this field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

bob said:
Hi guys,
I am using the following custom sort order :

Expr1: Switch([Accomodation - Unit]="object","a",[Accomodation - Unit]="
object","b",[Accomodation - Unit]=" object","c",[Accomodation - Unit]="
object","d",[Accomodation - Unit]=" object","e",[Accomodation - Unit]="
object","f",[Accomodation - Unit]=" object","g",[Accomodation - Unit]="
object","h",[Accomodation - Unit]=" object","i")
Click to expand...
 
thanks allen, a lot easier than the path i was taking. too many coffes and
not enough sleep..
cheers


Allen Browne said:
Create a table to hold all the various type of accomodation you need to
handle.

Add a field to that table that contains the "a", "b", etc.

Include that table in a query along with your main table.
Sort the query on this field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

bob said:
Hi guys,
I am using the following custom sort order :

Expr1: Switch([Accomodation - Unit]="object","a",[Accomodation - Unit]="
object","b",[Accomodation - Unit]=" object","c",[Accomodation - Unit]="
object","d",[Accomodation - Unit]=" object","e",[Accomodation - Unit]="
object","f",[Accomodation - Unit]=" object","g",[Accomodation - Unit]="
object","h",[Accomodation - Unit]=" object","i")
Click to expand...
this works fine but when i increase the number of objects past 14 i get
an error say that the expression is too complex.
Click to expand...
Click to expand...
 
Back
Top