Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding Best 2 of X

Status
Not open for further replies.
MTBChik

MTBChik

Technical User
Jun 19, 2001
58
US
I am trying to write a query that will take the best two sales for a single salesperson, then average them. Some salespeople have one or two sales, and some have several hundred.

My table is set up thusly:
SalesID, SalesAmount, SalesType

SalesType doesn't matter. I want to take all types in figuring out their average.

I'm guessing I'll have to write this in sql, but can't quite get access to cooperate.
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
3K
Moss100
Moss100
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
846
lameid
lameid
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
7K
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
474
cimoli
cimoli

Part and Inventory Search

Sponsor

Back
Top