field for last row in atable----robert bell specially

[Anonymous]

hi ,
sorry for calling robert specifically..i m stuck with this prob.i posted same type of question,but did not get answer.i have seen robert has solved field probs many times.i know robert "U have a job too" .but pl help me.
what to do to work in a field for diff. rows in a column?if i want to sum or multiply columns such as sum(D3:D5). but what about last row which is n no.
if n=6
"%<\AcExpr (Sum(D3:Dn)) \f ""%lu2"">%" or
"%<\AcExpr (Sum(D3:D(n))) \f ""%lu2"">%"

this field doesn't work.
pl help me .i m finding solution for reasonable amount of time.pl just give hint atleast.

thank u

[Anonymous]

You'll have to update the field's expression if you add new rows past the
previous range.

--
R. Robert Bell


wrote in message news:[email protected]...
hi ,
sorry for calling robert specifically..i m stuck with this prob.i posted
same type of question,but did not get answer.i have seen robert has solved
field probs many times.i know robert "U have a job too" .but pl help me.
what to do to work in a field for diff. rows in a column?if i want to sum or
multiply columns such as sum(D3:D5). but what about last row which is n no.
if n=6
"%<\AcExpr (Sum(D3:Dn)) \f ""%lu2"">%" or
"%<\AcExpr (Sum(D3:D(n))) \f ""%lu2"">%"

this field doesn't work.
pl help me .i m finding solution for reasonable amount of time.pl just give
hint atleast.

thank u

[Anonymous]

thank u robert.
what i was asking was if i have rows 1 to n.what will b sum of these rows.i just got answer after long search.
"=Sum(D3:D" & CStr(AreaTable.Rows - 1) & ")"
this will probably solve many of my problems i encountered.
field expression has many aspects,and not good material is available in help files.
thanks for taking pain always.

[Anonymous]

hi,
i want to divide a field in to two parts.some questions wr asked of same type.but thr r no answers.

Lvl = "%<\AcObjProp Object(" & CStr(adBlockAttributes(4).ObjectID) & ").TextString \f ""%bl2"">%"
Lvl1 = Split(Lvl, "Lvl. ", 2)
AreaTable.SetText RowNum, 3, Lvl1(1)

as Lvl is referenced to attribute i want new field (lvl1) also referenced to attribute value.for some reasons i dont want to divide attribute value in to two in block itself.
thank u

[Anonymous]

If "Lvl. " is consistent, you could use the substr DIESEL expression in the
field to remove "Lvl. ".

--
R. Robert Bell


wrote in message news:[email protected]...
hi,
i want to divide a field in to two parts.some questions wr asked of same
type.but thr r no answers.

Lvl = "%<\AcObjProp Object(" & CStr(adBlockAttributes(4).ObjectID) &
").TextString \f ""%bl2"">%"
Lvl1 = Split(Lvl, "Lvl. ", 2)
AreaTable.SetText RowNum, 3, Lvl1(1)

as Lvl is referenced to attribute i want new field (lvl1) also referenced to
attribute value.for some reasons i dont want to divide attribute value in to
two in block itself.
thank u

[Anonymous]

hello robert.thank u for reply.
i did this,i inserted field in to a field with diesel expression.
AreaTable.SetText RowNum, 3, "%<\AcDiesel $(substr,%<\AcObjProp Object(" & CStr(adBlockAttributes(4).ObjectID) & ").TextString \f ""%bl2"">%,6)>%"
the field expression is one field for example is,
%<\AcDiesel $(substr,Lvl. +2'6,6)>%
the result is 2'6
1....i can not update field by UPDATEFIELD command.i have to manually go and select and update specific field.
2.when instead of 2'6 it is 2'6" it gives XXXX.bcos of " character.
what is wrong in this.give suggestion.
pl also suggest whether we can use object.handle instead of object.objectid in field expression.
thankx