Element LIMS source query used to retrieve results for the interface:

SELECT w.SampleName as SampleName, s.Analysis as Analysis,  s.Analyte as Analyte, w.SampledTo as SampledTo, s.Result as Result ,s.Analyzed
        FROM sampleanalysis AS s, wrksample AS w
        WHERE s.Analyzed >= '01/01/2006'  AND s.Analyzed < '12/31/2006'
        AND s.Analyte is NOT NULL
        AND s.Result is NOT NULL
        AND w.SampledTo is NOT NULL
        AND s.wrk = w.wrk
        AND s.sample = w.sample
        ORDER BY s.Analyzed

NOTE:  The Result field is a real meaning there is no data qualifier.  Therefore, at this time the interface only imports numeric results.