Download database user`s manual - The Confederated Tribes Of The Colville

to do
3. Water Quality: I would like to see charts made of all the
values we/doe collect, by site, using a 12 year moving average
versus the current year. I have done this for some of the values in
the example.
4. Snorkel report: Please have a look at the report. The excel
sheet for the snorkel is what I would like to have in a report.
to do
5. Temperature: So far I have done the same for temperature as to do
flow. I would like to have this kind of report along with Johns
spread sheet report. (no excel sheet included)
Email from Mike Rayton dated May 11, 2007
This was sent to me today from Kris Peterson at NOAA Fish as an to do
example of the type of monthly report we need to submit in order
to remain in compliance with our smolt monitoring activities,
specifically, the write ups on pages 4 & 5.
Email from MR dated May 14, 2007
I have a question about parsing the rotary data.
RLqry_J__SpCounts_TRAP_NO
I believe that the Access program is tallying fish by calendar date NSAL_ENUM_trapping period
(00:00 hours through 23:59). This, unfortunately, does not
adequately reflect our trapping period. Since we trap from
approximately 19:00 to 04:00 hours on two separate calendar
days, the query counts fish collected from two separate overnight
periods (00:00 to 04:00 and 19:00 to 23:59).
Is there a way to write a query (I know there must be a way, but
easy way?) that solves this problem?
Phone Requests from KK and MR
How can we calculate the time spent each day in the traps
RLqry_K_TIMEDIFF
Appendix C2 - Page 2