Filter Help - Adagio Accounting | Technical Support Forums

Topic Options

#20966 - 02/11/10 09:55 AM Filter Help
George_H New Guy Registered: 02/11/10 Posts: 5 Loc: Canada	New user to Gridview. I am looking for help with a filter that will allow me to view the top 25 customers by selected amount. ie. I would like the filter to promt me the dollar amount I want to look at.
Top

#20967 - 02/11/10 10:01 AM Re: Filter Help [Re: George_H]
Retired_Guy Adagio Master Registered: 03/16/99 Posts: 10504 Loc: Canada	Hello George, Assuming you like to identify all customer's who's YTD purchases exceed a user entered amount, you'd use the filter: Code: {Inv Total - YTD} >= QUERYNUMBER("How large?",10000) Is this what you're looking for? _________________________ Andrew Bates
Top

#20968 - 02/11/10 10:06 AM Re: Filter Help [Re: Retired_Guy]
George_H New Guy Registered: 02/11/10 Posts: 5 Loc: Canada	Perfect, thank you.
Top

Moderator: Softrak Support

2 registered (Samuel Kopstick, Jesse_Gilbert), 91 Guests and 1 Spider online.

Key: Admin, Global Mod, Mod

Forum Stats

1865 Members
5 Forums
14501 Topics
70825 Posts

Max Online: 432 @ 01/20/25 10:17 PM