Min and max values

[Machinist]

Hello everyone,



I'm new to database creation, and have a question that I'm sure will be easy to answer for many of you. In Access 2010, I'm trying to create a query that returns the highest and lowest values from a single field. I have accomplished this returning "1" and selecting ascending or descending for the high or low values, but not able to return both. Will I have to create 2 querys like I described above and join them, or is there a way to filter out everything between the min and max values? Thank you, your help is very much appreciated.

[ssanfu]

How about:

SELECT Max([TheNumber]) AS MaxNum, Min([TheNumber]) AS MinNum
FROM Target;

where the field that has the numbers is named "TheNumber".

Disclaimer:
This is simplistic answer; it answers your direct question but may not be what you want because of other fields that would be included in the query. Not knowing what you are trying to accomplish, results in a limited answer.