SQL upit u Access-u

U access-u imam tabelu (id_coveka je PK):

id_coveka id_ugovora
001 2000
001 2001
002 2002
003 2003
003 2004
003 2005
004 2006
005 2007


Kako mogu pomocu SQL upita da prikazem sledece:
id_coveka broj_ugovora
001 2
002 1
003 3
004 1
005 1

tj. da prikaze ID lica i nihov broj ugovora

Hvala svima.

Pogledaj u helpu pod "Domain Aggregate Functions: DCount"

Potpis

"Take Five" is the famous jazz piece written by Paul Desmond and performed by The Dave Brubeck Quartet. It is famous for its distinctive saxophone line and use of the unusual quintuple (5/4) time, from which its name is derived.

Take Five (1966)

Take Five by Al Jarreau 1976

Mislim da u SQL-u to ide nekako ovako

SELECT id_coveka, count (id_coveka) FROM ime_tablice GROUP BY id_coveka

sad taj kod možeš kroz VBA koristiti u Access-u...