How to find top values accross multiple fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that was imported from an oracle database into access. The
database has sales dollar values for each branch of the organization for each
customer. I need to go across all branches and find the top 100. Not for each
branch, but for the organization overall. I need toe query to look at branch
1, branch2, and branch 3, and give me the top 100 dollar values as well as
the customer they sold to.
Thanks.
 
Try this --
SELECT TOP 100 [Jackie].Sales, [Jackie].Branch, [Jackie].Customer,
[Jackie].[SaleDate]
FROM [Jackie]
WHERE ((([Jackie].[SaleDate]) Between [Enter start date] And [Enter end
date]))
ORDER BY [Jackie].Sales DESC , [Jackie].Branch, [Jackie].Customer;
 
Back
Top