I need to find the top 5 customers for each salesposition and create a query or table that shows the Rank, Salesposition, Customer and Revenue where revenue is >0
My table has the following fields:
ID (unique)
Customer
SalesPosition
Revenue
So I would like to see something like this:
Rank...
My reports seems to lose the page setup after the report is closed. Can anyone give me some code that will preserve the layout once the report is saved? We generally set up our reports in landscape with .25 borders on each side.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.