Showing highest value

[Maikelos27]

Hi , I'm new to Access and I'm making some exercises to improve my skills. I have a problem with one query , I must show who bought the most laptops .I have reached a moment when I have sth like this.

Techland	402
Microsoft	352
My company	42

Now i need to query show only this Techland record and i dont know how to do that.
I hope u won't need any info about my database look cause its pretty big.



Thanks in advance

[alansidman]

Suggest you look at Aggregate Queries.

Here is a link

http://www.techonthenet.com/access/f...umeric/max.php