formular not working (1 Viewer)

[rainbows]

below is the query i run and it gives me this result
for this part number which is correct ie "issued to the shop floor"

yet when i select another part number it says " purchased " yet it should be the same as the first one

steve

 

[plog]

You need to use the right datatype for your data. You have stored numeric values as strings. They need to be stored as numbers if you want to do numeric operations/comparisons on them (+ - > < etc.).

The number 130 is greater than the number 80.

The string "130" is less than the string "80". That is because when you compare strings you compare character by character and "1" is less than "8".

Fix your datatypes and this will work.

 

[rainbows]

thank you . now works great