sql - MS Access Selecting Distinct Records -

sql - MS Access Selecting Distinct Records -

i using ms access 2010:

i working on calendar , show unique events types each day.. can help me out wit this..

this table looks

events

- event_id (pk) - event_type_id (fk) - event_name - event_date

this data:

1, 1, test event 0, 06/06/2014 2, 1, test event 1, 06/06/2014 3, 1, test event 2, 06/07/2014 4, 2, test event 3, 06/07/2014 5, 3, test event 4, 06/09/2014

i need query homecoming 1 event of each type each each date..

you can clever where clause:

select e.* events e not exists (select 1 events e2 e2.event_date = e.event_date , e2.event_type_id = e.event_type_id , e2.event_id > e.event_id );

this homecoming rows largest event id on each date each type.

sql ms-access-2010