I think you need to do something like:
Select First(Assay_Results.HoleID), First(Assay_Results.From),
First(Assay_Results.TO), First(Assay_Results.SampleNo),
First(Assay_Results.Znppm), Av(dhsusc.Magsus), Max(dhsusc.Magsus),
Min(dhsusc.Magsus)
>From Assay_Results, dhsusc
Where Assay_Results.HoleID = dhsusc.HoleID And magsus.At Between
Assay_Results.From And Assay_Results.To
Group By Assay_Results.HoleID, Assay_Results.SampleNo
Assuming that sampleNo is unique.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
Brendan.O'[EMAIL PROTECTED]
Sent: Monday, April 03, 2000 9:57 PM
To: [EMAIL PROTECTED]
Subject: MI Updating tables
Dear Listers,
I am trying to "get my head around" this problem. I have two tables of
down-hole data.
The first " Assay Results" is of the form (has these fields)
HoleID,From,To,sampleNo,Znppm
being respectively, the hole number, the from depth, the to depth, the
laboratory sample number and zinc concentration in ppm.
The second table "dhsusc" is of the form (has these fields)
HoleID, At, Magsus
being respectively the hole number, the depth at which the reading was
taken, and the magnetic susceptibility.
Typically Magsus has been measured at 10 cm intervals whereas the assays
are over intervals of about 1 to 2 metres.
I wish to determine averages, maxima and minima for Magsus within the Assay
intervals.
Any pointers would be gratefully received.
TIA Brendan O'Donovan Senior Geologist Tara Mines Ireland.
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
