Re: Number of records in a survey
I have a survey of 311,899 records. I know this because it has just been imported from another copy of R6 and I checked the size of the taxon occurrence file in the zipped access database. The report wizard gives the same number of records, so that's fine. However, xml reports produce a list of 312,242 records!
The selection in a typical xml report is
WHERE TDET.Preferred = 1
AND TOCC.Checked = 1
AND (TOCC.Verified = 0 or TOCC.Verified = 2)
AND TOCC.Zero_Abundance = 0
AND (Ln1.Preferred = 1 or Ln1.Location_key is null)
AND S.Spatial_ref_system = 'OSGB'
AND SV.SURVEY_Key = '%s'
This has happened before and has been bugging me for years. Presumably a few records are being duplicated, but how?
Janet
British Lichen Society