By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

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

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.
May 23 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
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!
:)
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.