R
R
I have a address subform on a persons form. I want to order the addresses by
the type of address (ie. Primary, Work, Parents etc). I have a field "Type"
which specifies what address it is, which I would use for the Orderby, BUT I
want the PRIMARY addresses to be first on the list. Unfortunatly, I can't
just do a DESC order because there are address types such as work or Uncle.
Is there some way I can specify the first type to show...I don't even care
if everything after is alph or not. I just want the Primary address to be
the one that shows first.
I am up to coding it if I have to but I don't know where to even start.
Thanks for any suggestions in advance.
the type of address (ie. Primary, Work, Parents etc). I have a field "Type"
which specifies what address it is, which I would use for the Orderby, BUT I
want the PRIMARY addresses to be first on the list. Unfortunatly, I can't
just do a DESC order because there are address types such as work or Uncle.
Is there some way I can specify the first type to show...I don't even care
if everything after is alph or not. I just want the Primary address to be
the one that shows first.
I am up to coding it if I have to but I don't know where to even start.
Thanks for any suggestions in advance.