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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding the range of two records in a grouped query

Status
Not open for further replies.
smuthcrmnl777

smuthcrmnl777

Technical User
Jan 16, 2006
104
US
I have a subgroup of 2 records that are grouped and one element is averaged. I would like to take the same element and find the range. The range is basically the Highest numeber subtract the lowest number no matter how many records you have. Is there a way to do this in a Grouped Query?
 
Sort by date Sort by votes
Have a look at the Max and the Min aggregate functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
476
dhookom
dhookom
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
971
strongm
strongm
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
676
mikrom
mikrom
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
600
rashmibala
R

Part and Inventory Search

Sponsor

Back
Top