"Order by" in a report - different ones for 3 alpha bars

P

P Straube

hello,
I have a database of contacts. In one report, I have
three alpha bars to locate people based on last name,
maiden name, or first name. After adding the 2nd and 3rd
bar, I can't get the names to sort the way I want. I
believe I need to use "Order By" with a macro or other
expression that would be triggered after clicking on a
button (letter) of the alpha bar. Each bar would trigger
a different sort order so I would need three in total
I'm at a loss on this and I can't find any examples to
helk me with this.
Any help will be appreciated.
Thank you.
 
C

Cheval

What's an "Alpha Bar"? Also I've never seen a report that
you could interact with. The best help that I can think of
is in the Report OnOpen event has a selection form open
asking the order and then set the OrderBy in the report
from that.
 
Top