sembra facile...help

G

gindolfi

I have a table:

COUNT NAME

1 ROSSI
2 BIANCHI
3 BIANCHI
4 VERDI
5 ROSSI

I need a report with no name repetition (just the last one)

COUNT NAME

3 BIANCHI
4 VERDI
5 ROSSI

What is the way? Thanks.
 
A

Al Campagna

A Totals query should do it, Grouped on Name, and probably Last on Count.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
D

Dirk Goldgar

In
Al Campagna said:
A Totals query should do it, Grouped on Name, and probably Last on
Count.
Click to expand...

The Last() SQL aggregate function is a very tricky animal. Remember
that the order of records in tables is arbitrary. Gindolfi, do you
really want the "last" record for each NAME, or do you want the one with
the maximum value of COUNT?
 
Top