If we follow the the instructions for creating a species list for a vice county, there is one additional step, which is adding a ‘subdivide’ clause via more options > grouping.
‘Subdivide’ adds additional columns to the output of the query, giving the number of records for each taxon in each date class period.
![](https://docs.bsbi.org/media/pages/ddb/searching/example-searches/species-vc-by-date/0b35100f3d-1700063518/screenshot-2023-10-09-at-11.52.18-600x.jpg)
This query can be modified to give a count of hectads for each species in each date class, by adding a more options > grouping > distinct clause to the query, and selecting hectad.
![](https://docs.bsbi.org/media/pages/ddb/searching/example-searches/species-vc-by-date/ad6d05591e-1700063519/screenshot-2023-10-09-at-11.57.33-600x.jpg)
Because old historic records are often only available at hectad resolution (at best) running this query at the hectad precision level is sensible as it allows comparison over many decades.