SELECT DISTINCT on last date

[anselme]

Hello I am having a MS Access 2000 Table

Table1
id (autoincrement) | id_users (integer) | LastVisit (date)

i want to get id, id_users, lastVisit

to get a list of each users (distinct) for the lastvisit (max(date))

thank you

[MAK]

select id, id_users, max(lastvisit) from tablename group by
id,id_users

[anselme]

thank you Mak