B
BurnTHalO
I am currently working with a database which has basins, streams, and years.
There are other things as well, but these are what I am concerned with. I
need to determine the number of streams in each basin, and the number of
years in each stream. the problem I am running into is that they may be
there multiple times, but I need them only counted once. For example, I have
150 rivers in basin 1, but there are 10000 records, with streams being
located multiple times. Every time I set up to count, it is counting the
total number of records, not of just the streams. In other words, I'm
getting 10000 for my count, not 150. I'm new to using Access so I was
wondering if someone could help me wit this. Thanks.
There are other things as well, but these are what I am concerned with. I
need to determine the number of streams in each basin, and the number of
years in each stream. the problem I am running into is that they may be
there multiple times, but I need them only counted once. For example, I have
150 rivers in basin 1, but there are 10000 records, with streams being
located multiple times. Every time I set up to count, it is counting the
total number of records, not of just the streams. In other words, I'm
getting 10000 for my count, not 150. I'm new to using Access so I was
wondering if someone could help me wit this. Thanks.