counting fields

[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.

 

[Golfinray]

I find it easier to just build a separate query. Put in streams and count
those. Put in basins and count those, sum them or whatever. Then bring those
small queries back into the main query and you now have your counts without
trying to separate all the other stuff out.

 

[Dale Fye]

Can you give us the names of the fields in your tables, and how these tables
are related to one another?

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.