Search results

  1. C

    Select Case Statement

    I am trying to write a select case statement module which using 3 tables; COVERAGE, TABLEC1 AND TABLEC2. The statement 1) anchors the distinct value from a table (TABLEC1), 2) goes through 4 select case scenarios based on TABLEC2 ORDER, 3) updates a table (COVERAGE) with the best result and 4)...
  2. C

    If-Then-Else or Case Statement

    I have 2 tables, table 1 and table 2. I am trying to find the best coverage match from table 2 for the vehicle (VIN) on table 1 based upon the VINs information in table 1. I have a serious of logic steps in an If-Then-Else format, but I am not sure of the proper verbiage/syntax or how to apply...
  3. C

    Parameter Query Question

    Hi, I am casaler (Robert) and self taught in most Office programs. I do have a question (need help on) regarding using a user's input data on a form, and it doesn't match a record in a table, then convert it to "-" which is on the table. Suggestions? If need be, I could provide my database(s)...
  4. C

    New Member Intro

    Hi, I am casaler (Robert) and self taught in most Office programs. I do have a question (need help on) regarding using a user's input data on a form, and it doesn't match a record in a table, then convert it to "-" which is on the table. Suggestions? If need be, I could provide my database(s)...
Top Bottom