Simple Query

S

Sheila

Hi. I'm a fairly new user with Access. I have a simple query that I would
like to run which is to get the highest and lowest values from a list. What
is the best approach to this? Any advice would be helpful. Thank you.
 
D

Duane Hookom

I'm not sure what you mean by "from a list". I assume this might be a
table???? Also, I assume you are referring to a value in a field.

SELECT Max([Yourfield]) as TheMax, Min([YourField]) As TheMin
FROM [Your Table];
 
K

Ken Snell [MVP]

Create a totals query:

SELECT Max(FieldName), Min(FieldName)
FROM Tablename;
 
Top