S
Stephen
I have an .ADP file and one of teh views shows that summary information for
each account (i.e. total number of order, total volume , average oprder
size, etc). This information is shown on teh customer profile form via a
"account summery subform".
Ahother piece of informatin that I am trying to show is the relative
"importance" of this customer. For example, if this customer's sales volume
is the highest of all our customers, then I want to give this customer a
ranking of "1". If this customer's sales volume is the 12th highest, I want
to give them a rankin gof "12".
Is there way in the SQL view to show the relative position in the view of
the customer? I know that there are some other functions likechecksum, but
I am not sure if any of these would achieve my goal?
Thoughts?
each account (i.e. total number of order, total volume , average oprder
size, etc). This information is shown on teh customer profile form via a
"account summery subform".
Ahother piece of informatin that I am trying to show is the relative
"importance" of this customer. For example, if this customer's sales volume
is the highest of all our customers, then I want to give this customer a
ranking of "1". If this customer's sales volume is the 12th highest, I want
to give them a rankin gof "12".
Is there way in the SQL view to show the relative position in the view of
the customer? I know that there are some other functions likechecksum, but
I am not sure if any of these would achieve my goal?
Thoughts?