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?
 

Ruffnekk

Member
Joined
Mar 17, 2005
Messages
17
Location
Rotterdam, Netherlands
Programming Experience
10+
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).
 
Top Bottom