comparing two values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jerry (Jerry_at_discussions.microsoft.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 12:23:05 -0800

I have two columns: Col1: A and Col2: C, some values may be Col1: C and Col2:
A or some other ones may be Col1: A and Col2: A. Values range from A to F.
What I want to display is: if Col2 is less than Col1 display "Dropped", if
col2 is greater than col1 display "Improved", if col1 and col2 are the same
display "No change". Your assistance is greatly appreciated. Jerry

Relevant Pages

  • Re: more than 1 bound column?
    ... but you can get (or display) the value from Col2 or Col3. ... (Combos cols are numbered 0,1,2,3) ... Candia Computer Consulting - Candia NH ...
    (microsoft.public.access.formscoding)
  • How to accomplish?
    ... We generate a worksheet once a week that has 4 columns. ... if col2 is large, display a different image in a cell on the same sheet. ... Loop through all the users, compare the values of col2 & 3 for each of them and display a image in a seperate cell, say col 5?? ...
    (microsoft.public.excel.programming)
  • Re: Inserting multiple records into two tables...with a twist
    ... I assume that you have an IDENTITY column, ... reason would typically be a high rate of concurrent insertions.) ... INSERT tblB(id, col1, col2, ... ...
    (comp.databases.ms-sqlserver)
  • Dynamic PreparedStatements with Variable In Parameters
    ... AND col2=? ... AND col3=? ... I have to start coding tomorrow so I'm eager ...
    (comp.lang.java.programmer)
  • Re: Required property of Primary Key fields
    ... col1 INTEGER NOT NULL, ... PRIMARY KEY (col1, col2) ... it's a bit pointless because the INSERT will fail with a "primary key ...
    (microsoft.public.access.tablesdbdesign)