3D Block Model - Referencing adjacent blocks (records)?

[Jimbo Jones]

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.

[PEB]

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!
:)