choose function

R

Renee

On my new form I trying to have a custom find/sorting report. I am using a
group option filter to do this. On the Select report I would like to have for
example Coats, Jackets etc. and on the Filter option I would like to have
Option #1 to sort it out by Color, Option # 2 by Material. How can I type out
a formula to get what I need. Please Help. Thanks!
 
J

John W. Vinson

On my new form I trying to have a custom find/sorting report. I am using a
group option filter to do this. On the Select report I would like to have for
example Coats, Jackets etc. and on the Filter option I would like to have
Option #1 to sort it out by Color, Option # 2 by Material. How can I type out
a formula to get what I need. Please Help. Thanks!

How depends on what. Nobody here can see your computer, and we have no idea
how your tables are structured or what you mean by the "filter option". More
info please?
 
Top