S
schongresh
I am trying to query a database that will include building some
calculated fields. I am having trouble with the conditions I am trying
to place on the calculations. An example is: IIf([recShortName]<>"sm/
WASH TRACTORS" OR "sm/WASH ALL TRAILERS" OR [recShortName] Not Like
"bnsf*", Nz([bilUnit1],0)+Nz([bilUnit2,0),0)
If the records recShortName is not "sm/WASH TRACTORS" OR "sm/WASH
ALL TRAILERS" OR does not contain the text "bnsf" then I want to add
the fields bilUnit1, bilUnit2, etc. The way I have it written above is
obviously incorrect, because the calculated field is adding the fields
for each record. Please help me straighten out the conditions I am
trying to place on the calculated fields.
Thanks So Much
calculated fields. I am having trouble with the conditions I am trying
to place on the calculations. An example is: IIf([recShortName]<>"sm/
WASH TRACTORS" OR "sm/WASH ALL TRAILERS" OR [recShortName] Not Like
"bnsf*", Nz([bilUnit1],0)+Nz([bilUnit2,0),0)
If the records recShortName is not "sm/WASH TRACTORS" OR "sm/WASH
ALL TRAILERS" OR does not contain the text "bnsf" then I want to add
the fields bilUnit1, bilUnit2, etc. The way I have it written above is
obviously incorrect, because the calculated field is adding the fields
for each record. Please help me straighten out the conditions I am
trying to place on the calculated fields.
Thanks So Much