How to find top values accross multiple fields

[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.

 

[Guest]

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;