Recent content by t.p.lyons

Hi, Thanks for your response. I do in fact have a table that has only one row for each nest (NestID is the primary key) and data about where it was, the species, etc. It is linked to the table I previously mentioned, that describes each visit to a nest. There are actually a host of tables...

I'm working with a table of bird survival data I am trying to summarize in a query. I've got a bit of a roundabout way to achieve my goal, but I'm curious if there is a simpler approach. Background: In my table, each row represents a day I check a given nest and includes a [Nest ID] (not...