answersLogoWhite

0

You can use the Max function and the Min function in a query to do it. They are both available when you use the Totals row in the query design grid.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you find the maximum and range?

the maximum is whatever the biggest number is and the range is the maximum (the largest number) minus the minimum (the smallest/lowest number)


How do you find the range in data handling?

maximum number-minimum number = range


How do you find a range in numbers?

the range of the number is the maximum minus the minimum.


Q1 Find the minimum and the maximum number of keys that a heap of height h can contain?

Q1. Find the minimum and the maximum number of keys that a heap of height h can contain.


Find the range of the set of numbers?

Find the minimum and maximum values from the given data. Then range is the difference between maximum and minimum values.


How do you find range math?

subtract the minimum from the maximum


How to find max and min values?

Find the minimum and maximum of what? An array?


How do you find the minimum or maximum of a function?

By taking the derivative of the function. At the maximum or minimum of a function, the derivative is zero, or doesn't exist. And end-point of the domain where the function is defined may also be a maximum or minimum.


How can you find a range in science data?

In science, the range of a data set is the difference between the highest and lowest values. Steps to Find the Range: List the Data Points: Gather all your numerical values from the experiment or observation. Example: 12.4, 15.6, 11.2, 14.0, 13.5 Identify the Maximum and Minimum Values: Maximum = highest number → 15.6 Minimum = lowest number → 11.2 Calculate the Range: Range = Maximum − Minimum Range=Maximum−Minimum Range = 15.6 − 11.2 = 4.4 Range=15.6−11.2=4.4


How do you find the range of 2 16 32 15 3 9 7?

Range = Maximum - Minimum = 32 - 2 = 30.Range = Maximum - Minimum = 32 - 2 = 30.Range = Maximum - Minimum = 32 - 2 = 30.Range = Maximum - Minimum = 32 - 2 = 30.


How do you find minimum and maximum possible area?

the butt flys


How do you draw a flowchart to find maximum and minimum of given 3 input numbers?

You draw a flowchart to find maximum and minimum of given 3 input numbers by using all three numbers. You take the low, high and input the middle number between them. You can see the rise, or decline of the chart that way.