G
Guest
Hi friends
Maybe this question is already somewhere answered, but as English is not my
mother language, maybe I have not found it. The problem:
I have a table with sales contracts. the relevant fields are:
contract number, shipping date, salesperson. regionalmanager
What I need is the table grouped by salesperson and within this group sorted
by shipping date and to this I need an increasing autonumber, starting again
at each salesperson.
the query will be filterd from a form by the name of the regionalmanager, so
the output will be a list, where we see the sales of each sales person of the
selected region with an autonumber, showing the ranking of the sales. The
reason for this is that the region manager gets an extra commission, which is
decreasing on the first 3 sales of each sales person (but the query must not
be limited to 3 records and don't worry about the commsionnsion calculation).
The only problem is: it should be quite quick as we have other querries
running at the same time for the total commission calculation on the form.
I know, on a report this is easy, but I need a query, for the reasons above.
Thanky for all help, it is just too complex for me
All the best from wet Prague
Maybe this question is already somewhere answered, but as English is not my
mother language, maybe I have not found it. The problem:
I have a table with sales contracts. the relevant fields are:
contract number, shipping date, salesperson. regionalmanager
What I need is the table grouped by salesperson and within this group sorted
by shipping date and to this I need an increasing autonumber, starting again
at each salesperson.
the query will be filterd from a form by the name of the regionalmanager, so
the output will be a list, where we see the sales of each sales person of the
selected region with an autonumber, showing the ranking of the sales. The
reason for this is that the region manager gets an extra commission, which is
decreasing on the first 3 sales of each sales person (but the query must not
be limited to 3 records and don't worry about the commsionnsion calculation).
The only problem is: it should be quite quick as we have other querries
running at the same time for the total commission calculation on the form.
I know, on a report this is easy, but I need a query, for the reasons above.
Thanky for all help, it is just too complex for me
All the best from wet Prague