Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Custom sort order

Discussion in 'Information Technology' started by bob, Jul 28, 2006.

Tags:
  1. bob

    bob
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    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.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "bob" <Alpha@O.com> wrote in message
    news:e8dgvi$jft$1@otis.netspace.net.au...
    > 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.
     
  4. bob

    bob
    Expand Collapse
    Guest

    thanks allen, a lot easier than the path i was taking. too many coffes and
    not enough sleep..
    cheers


    "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
    news:uWeZLi1nGHA.3320@TK2MSFTNGP04.phx.gbl...
    > 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.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "bob" <Alpha@O.com> wrote in message
    > news:e8dgvi$jft$1@otis.netspace.net.au...
    >> 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.

    >
    >
     

Share This Page