i have 2 numeric fields and i want to compare them helppppppppppp

  • Thread starter Thread starter asyyyya via AccessMonster.com
  • Start date Start date
A

asyyyya via AccessMonster.com

i have 2 numeric fields and i want to compare them
if the values of the filelds are "equal" i want to create a new field with
the values "not ok" , else "ok"
i wat to do this in sQL plssssssssssssssssssssss
 
In the query grid, add a calculated column (field) like the following.

Field: CheckThem: IIF([Field1] = [Field2], "OK", "Not Ok")
 
Back
Top