sembra facile...help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gindolfi - 16 Mar 2007 13:19 GMT

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.

Reply to this Message

Al Campagna - 16 Mar 2007 14:20 GMT

A Totals query should do it, Grouped on Name, and probably Last on Count.

Signature

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."

>I have a table:
>
[quoted text clipped - 15 lines]
>
> What is the way? Thanks.

Reply to this Message

Dirk Goldgar - 16 Mar 2007 19:08 GMT

> A Totals query should do it, Grouped on Name, and probably Last on
> Count.
[quoted text clipped - 17 lines]
>>
>> What is the way? Thanks.

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?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message