Multiple Column Calculation Issue

[PD1978US1]

I have a query which displays "WEIGHT_VALUE" of a particular order in a column and the value is appended to a table later.
Next to the column I have two columns called 'nr of cartons' and 'nr of pallets'
Can I somehow have this table automatically adjusted to state the following: If weight is >25 then it places a 1 in the coherent field and vice versa.

Or does this have to be done in excel later on?

 

[isladogs]

Use an IIf statement in your query.
Not sure what you mean by vice versa so I'll assume 0.

iif([weight_value]>25,1,0)

Advise you to remove spaces in field names. Use CamelCase instead

 

[arnelgp]

Is it on nr pallet field you are talking about,

[Nr of pallets]: weight_value \ 25