Data at once

brix_zx2

Member
Joined
Apr 6, 2005
Messages
12
Location
Altus AFB
Programming Experience
1-3
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?
 
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).
 
Back
Top