Lorna,

This is the query I use to export data from MapMate, It is based on exporting between two MapMate Generations (admittedly because I store all my exported MapMate data in different surveys for each CUK, I also have the same routine with a CUK filter as well) - it is not 100% reliable because of the way MapMate marks records as edited, changing the Generation to negative, rather than changing it to the generation in which it was edited!

SELECT Records.[_guk], Records.[_guk] AS MapMate_Key, Records.[_guk] AS MapMate_ID, [Taxa\Default].Taxon AS Species_Name, [Sites\Default].Name AS Location, [Sites\Default].OSGridRef AS Grid_Reference, IIf([Sites\Default].[ViceCounty]>200,'H' & [Sites\Default].[ViceCounty]-200,[Sites\Default].[ViceCounty]) AS Vice_county_Number, (IIf(Records.Quantity=-1, 'd', IIf(Records.Quantity=-2, 'a', IIf(Records.Quantity=-3, 'f', IIf(Records.Quantity=-4, 'o', IIf(Records.Quantity=-5, 'r', IIf(Records.Quantity=-6, 'vr', IIf(Records.Quantity=-7, 'NotPresent', IIf(Records.Quantity=0, '+', Records.Quantity))))))))) & " " & IIf([Records]![*Stage]='0',"",IIf([Records]![*Stage]='1',IIf([Records]![*Sex]<>'u','Adult ' & [TaxonSex]![Sex],'Adult'),[TaxonStage]![Stage])) & " " & IIf([Records]![*Sex]<>'u' And [Records]![*Sex]<>'',[TaxonSex].[Sex],"") AS Abundance_Data, [RecordStatus].[Status] AS Record_Type, Methods.Method AS Sampling_Method, 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 Observers, Recorders_1.Name AS Determiner_Name, Records.Comment AS Comment, [References].[Author] & " (" & [References].[Year] & "): " & [References].[Title] AS Publication_Reference, Abs(Records.[_gen]) AS Generation
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]) LEFT JOIN [References] ON Records.[*Reference] = References.[_guk]) INNER JOIN Recorders AS Recorders_1 ON Records.[*Identifier] = Recorders_1.[_guk]) INNER JOIN RecordStatus ON Records.[*Status] = RecordStatus.[_guk]
WHERE ((Abs([Records].[_gen])>[Enter Last Generation already exported - eg 224]) And (Abs([Records].[_gen])<=[Enter last Generation to be exported - eg 300]);

The reason the MapMate CUK is exported twice is that I use it to create the Recorder GUI and add it to 'Surveyor's Ref' to allow comparison with original MapMate data
Craig