Filtering (1 Viewer)

Hello,

I'm completely new in using the Access and I cannot manage how to clear my large database. My problem is as follows, I have a database like this (ID|Name|Number):

1|BannedOak|2.46
2|BannedOak|3.85
3|BannedOak|8.5
4|BannedOak|12
5|BannedOak|25
6|BannedOak|1.02
7|Someone|3.14
8|Someone|6.8
9|Someone|11

What I need is to find out the line with the unique Name and maximum value of Number, and minimum value of Number. So, after this the database would consist:
5|BannedOak|25
6|BannedOak|1.02
7|Someone|3.14
9|Someone|11


Can someone give me a hint or a solution how to do that?

Thanks in advance,
Dean

Hi,
This can be obtained like this:

SELECT Table1.Name, Max(Table1.Number) AS MaxOfNumber
FROM Table1
GROUP BY Table1.Name;

Click to expand...

Hope this give some idea!

To bring back both Maximum and Minimum values in the same query you may consider using a Union; like:
Chris