R
Ryan Fisher
Hi everyone,
Thanks for the quick responses I've had here in the past and this
post related somewhat to a previous post, but I will reiterate what
I'm working with. I have two tables in Access. The first table
contains information on
visits to bird's nests. It contains fields: [VisitID], [NestID],
[WeatherStationID],[DateoftheVisit],[DateofPreviousVisit]. [VisitID]
is the identification code for the particular visit (autonumber
field),
[NestId] is the identification code given to the particular nest,
[WeatherStationID] is the closest weather station, [DateoftheVisit]
is
the date of the current visit (mm/dd/yyyy), and [DateofPreviousVisit]
(mm/dd/yyyy) is the date of the previous visit to the nest. The
second
table contains information on daily precipitation from various
weather
stations, so this table has three fields: [WeatherStationID], [Date]
(mm/dd/yyyy), and [Precipitation]. How this query differs from my
previous post is this. What I would like to do now is get the number
of times Precipitation was >7mm three days in a row between
[DateofVisit] and [DateofPreviousVisit]
for each nest for the weather station that is closest to it. For
example, if a visit to a nest was conducted on 06/01/2004 and then on
06/05/2005 and precipitation for 06/01,
06/02, 06/03, 06/04, and 06/05 was 7mm, 1mm, 10mm, 11mm, and 12mm then
the query would return 1 (i.e., there was one 3 day period where
rainfall was >7mm). I hope I've included enough information
and in the correct format...kind of a newbie here.
Thanks!
Thanks for the quick responses I've had here in the past and this
post related somewhat to a previous post, but I will reiterate what
I'm working with. I have two tables in Access. The first table
contains information on
visits to bird's nests. It contains fields: [VisitID], [NestID],
[WeatherStationID],[DateoftheVisit],[DateofPreviousVisit]. [VisitID]
is the identification code for the particular visit (autonumber
field),
[NestId] is the identification code given to the particular nest,
[WeatherStationID] is the closest weather station, [DateoftheVisit]
is
the date of the current visit (mm/dd/yyyy), and [DateofPreviousVisit]
(mm/dd/yyyy) is the date of the previous visit to the nest. The
second
table contains information on daily precipitation from various
weather
stations, so this table has three fields: [WeatherStationID], [Date]
(mm/dd/yyyy), and [Precipitation]. How this query differs from my
previous post is this. What I would like to do now is get the number
of times Precipitation was >7mm three days in a row between
[DateofVisit] and [DateofPreviousVisit]
for each nest for the weather station that is closest to it. For
example, if a visit to a nest was conducted on 06/01/2004 and then on
06/05/2005 and precipitation for 06/01,
06/02, 06/03, 06/04, and 06/05 was 7mm, 1mm, 10mm, 11mm, and 12mm then
the query would return 1 (i.e., there was one 3 day period where
rainfall was >7mm). I hope I've included enough information
and in the correct format...kind of a newbie here.
Thanks!