Simple Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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];
 
Create a totals query:

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