The three queries below, using Moray (vc95) in 2022 as an example, illustrate different approaches that may be taken.
The first query lists all records for taxa listed as Nationally Rare or Nationally Scarce in vc95 in 2022. It does so irrespective of whether the taxa are native in vc95, or in that hectad.
We do this by adding more options > attributes > conservation status summary, and selecting Nationally rare or scarce.
As of October 2023 this query returns 227 records.
You can enter either rare or scarce into the Nationally rare or scarce field to filter down as required.
The query can be restricted to only returning records where the taxa are listed as native in each hectad in Atlas 2020. The modification to the query is included via more options > attributes > status (external scheme), selecting native and Atlas 2020.
This query returns (as of October 2023) 59 records. But this query excludes any records for hectads where the taxon had not been recorded in Atlas 2020. To list these records you need to modify this query, changing the status (external schema) field to no status information
This last query returns (as of October 2023) 9 records. Some of these will be new hectad records of native species, while others will be new hectad records of alien species (in this vice-county).