calculated field with conditions

[schongresh]

In the query design view I am trying to make a calculated field total
certain amounts based upon the contents of a certain field. The
statement reads:

IIf([recShortName]<>"sm/TRACTORS" Or "sm/WASH ALL TRAILERS" Or
[recShortName] Not Like "bnsf*",Nz([bilUnit1],0)+Nz([bilUnit2],
0)...etc.,0)

The field is calculating in each record whether or not recShortName
matches or not. I would like some guidence on how to arrange to
statement with the proper syntax and logic.

The goal is to find to records where [recShortName] does not equal "sm/
TRACTORS" or "sm/WASH ALL TRAILERS" or does not contain the text "bnsf
".

 

[Dirk Goldgar]

In

In the query design view I am trying to make a calculated field total
certain amounts based upon the contents of a certain field. The
statement reads:

IIf([recShortName]<>"sm/TRACTORS" Or "sm/WASH ALL TRAILERS" Or
[recShortName] Not Like "bnsf*",Nz([bilUnit1],0)+Nz([bilUnit2],
0)...etc.,0)

The field is calculating in each record whether or not recShortName
matches or not. I would like some guidence on how to arrange to
statement with the proper syntax and logic.

The goal is to find to records where [recShortName] does not equal
"sm/ TRACTORS" or "sm/WASH ALL TRAILERS" or does not contain the text
"bnsf ".

IIf(([recShortName]<>"sm/TRACTORS" And
[recShortName]<>"sm/WASH ALL TRAILERS")
Or [recShortName] Not Like "*bnsf*",
Nz([bilUnit1],0)+Nz([bilUnit2],0)...etc.,
0)