SELECT Records.[_guk] AS MapMate_guk, [Taxa\Default].Taxon, [Sites\Default].Name AS Location_name,
[Sites\Default].OSGridRef AS Gridref, 
IIf([Sites\Default].[ViceCounty]>200,'H' & [Sites\Default].[ViceCounty]-200,[Sites\Default].
[ViceCounty]) AS Vice_county, IIf([Records].[Quantity]>0,[Records].[Quantity],'Present') & " "
 & IIf([Records]![*Stage]='0',IIf([Records]![*Sex]<>'u',[TaxonSex]![Sex],'None'),
IIf([Records]![*Stage]='1',IIf([Records]![*Sex]<>'u','Adult' & [TaxonSex]![Sex],'Adult'),
[TaxonStage]![Stage])) AS Abundance, IIf([Records].[DateTo]-[Records].[Date]<27,Format([Records].[Date],'dd/mm/yyyy'),
IIf([Records].[DateTo]-[Records].[Date]>32,Format([Records].[Date],'yyyy'),Format([Records].[Date],'mmmm yyyy'))) AS [Date],
 Recorders.Name AS Recorder, Recorders_1.Name AS Determiner, Methods.Method, Records.Comment
FROM ((((((Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) 
INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk]) INNER JOIN Methods ON Records.[*Method] = Methods.
[_guk]) INNER JOIN Recorders ON Records.[*Recorder] = Recorders.[_guk]) INNER JOIN TaxonStage ON Records.
[*Stage] = TaxonStage.[_guk]) INNER JOIN TaxonSex ON Records.[*Sex] = TaxonSex.[_guk]) INNER JOIN Recorders 
AS Recorders_1 ON Records.[*Identifier] = Recorders_1.[_guk]
WHERE ((([Sites\Default].OSGridRef) Is Not Null));