P: 1

G'day,
I have a table of records representing a 3D block model of an orebody, such that each block has X, Y, Z and then properties (grades), such as Ni, RecNi, Cu etc, as well as 2 volume fields, MinVol and DilVol. Each block is 20m apart in X, 20m apart in Y and 10m apart in Z.
So 2 adjacent blocks would have coordinates:
X(8510), Y(19500), Z(100)
X(8530), Y(19500), Z(100)
I am trying to write an update query that takes each record that has RecNi>=0.18, and looks at the record (block) next to it, and depending on the value of RecNi being <0.18 in the adjacent block, will add 1000 to DilVol and subtract 1000 from MinVol.
I have been trying to use DLookUp as such:
Field:
DLookUp("RecNi","3DBlockModel","[X]=" & [X]+20 And "[Y]=" & [Y] And "[Z]=" & [Z])
Criteria:
<0.18
but this does not return any value. Is my syntax wrong?
Thanks for any help,
Jimbo.
 
Share this Question
Expert 100+
P: 1,418

G'day,
I have a table of records representing a 3D block model of an orebody, such that each block has X, Y, Z and then properties (grades), such as Ni, RecNi, Cu etc, as well as 2 volume fields, MinVol and DilVol. Each block is 20m apart in X, 20m apart in Y and 10m apart in Z.
So 2 adjacent blocks would have coordinates:
X(8510), Y(19500), Z(100)
X(8530), Y(19500), Z(100)
I am trying to write an update query that takes each record that has RecNi>=0.18, and looks at the record (block) next to it, and depending on the value of RecNi being <0.18 in the adjacent block, will add 1000 to DilVol and subtract 1000 from MinVol.
I have been trying to use DLookUp as such:
Field:
DLookUp("RecNi","3DBlockModel","[X]=" & [X]+20 And "[Y]=" & [Y] And "[Z]=" & [Z])
Criteria:
<0.18
but this does not return any value. Is my syntax wrong?
Thanks for any help,
Jimbo.
Hi,
As Field try the following:
DLookUp("RecNi","3DBlockModel","[X]=" & Str([X]+20) And "[Y]=" & Str([Y]) And "[Z]=" & Str([Z]))
Hope that works!
:)
Have a nice day!
:)
    Question stats  viewed: 1980
 replies: 1
 date asked: May 23 '06
