POSSIBLE to create a View table in access databas

I work with ado and vb6 classic.
i need to create a Select distinct (or group by) from Table1 the filed data into Field1 and store data filtered in View1filed filed2, how to?