I’m using 3 tables. SpeciesData (fields: Genus, Species, CommonName) , PlantData (fields: Action, NumPlants) , EventData (fields: Location, EventDate). Of course there are various ID fields to relate the tables.I have no problem creating a simple query showing the number of seedlings (by species) planted in total for a given date range but what I really need is to report on how many seedlings were planted (Action=plant) in Location 1 in Q1 (1July-30Sept), Location 1 Q2 (1 Oct-31Dec) Location 2 Q1, Location 2 Q2, etc....All in one table for comparison. I have tried various things in the query like using DSum to create a new field and specifying the criteria, but nothing works. I’m not even sure if it is possible to use DSum if the fields for the necessary criteria are in different tables.
I would be very grateful for any help!