Data at once

[brix_zx2]

vb .net 2k3 app using microsoft access 2k as db:

I want to be able to go through my data and find a new instance of one value in column1. When I get a new instance I want to be able to look at the values in column2 (only 5 values possible) and count the occurence of the values. After that is done I want to go back to column1 looking for new values. any ideas on how to do that?

 

[Ruffnekk]

So you want to count records with a same value in column 2 and a different value in column 1 if I understand correctly. You could simply use the DISTINCT keyword in your SQL query (google it up, it's easy to find an example).

 

[brix_zx2]

Yea that's what I ended up doing, it was hard trying to find the exact way I needed to do it but I eventually figured it out. Thanks.