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

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200605/1
.

Relevant Pages

  • Re: how to compare date
    ... Date/time fields in Access are really numeric fields of type Double, ... by default formatted as some date format for display, ... if you want to compare ...
    (microsoft.public.access.queries)
  • Re: How to compare fields
    ... >I need to compare three numeric fields and pick the greater of the three; ... >will then have to use that number in subsequent calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: How to compare fields
    ... > I need to compare three numeric fields and pick the greater of the three; ... > will then have to use that number in subsequent calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Formula or Numeric Formatting Issue
    ... tables and compare the results to identify data entry errors. ... comparing two numeric fields (Numberic, Double, decimal place set to auto), ... I encountered errors that are not actual errors. ...
    (microsoft.public.access.reports)
  • How to compare fields
    ... I need to compare three numeric fields and pick the greater of the three; ... will then have to use that number in subsequent calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
Loading