Hi, I'm seeking some help, please, with a query that's beyond me. It's to do with the 'effort' accumulated by numerous trailcams (automatic wildlife cameras) across different waterside sites: Here's the situation:
1. In a Table (named 'Deployment') I have one record per camera deployment. That record includes the start date, pickup date and location.
2. In a Table named 'Site' I have one record per location, including sitename, county, river.
I want to be able to discover the effort (defined as the number of camera nights) accumulated across all cameras between date A and date B in, say, County A or River B. And I'd like to know how many cameras were active and therefore contributed to that effort total.
I'm familar with how to set up a parameter query to ask the question; what I can't work out is how to use the data in my Deployment Table (including deployments with no pickup date because the camera is still active at that location) to give me the info I need.
I'd be hugely grateful for guidance, please.