Search results

  1. A

    Missing Operator

    also, the equal in the middle is an "and"
  2. A

    Missing Operator

    I assume I am missing the JOIN portion. Sorry, pretty new to access. Looking to find a value based on if it meets the two cireterias. SELECT fldCOLA, WHERE qryColaSalaryNum.COLA = COLArate.fldPercentage = qryColaSalaryNum = COLArate.fldSalaryRange FROM COLArate; I also want it...
  3. A

    Seaching a Table

    Yea, so the 50% is based on the location. I have a separate table that has the COLA already % by location and then the table referenced has it already linked to each individual. This is the percent that would be found in the column headings. If I changed the headings, what would the lookup...
  4. A

    Seaching a Table

    Its a calculation base on location. Its a benefit amount that is received based on the two factors. 1. Salary Range 2. The percentage is based on location. The table is provided, not sure of a better way to display the table.
  5. A

    Seaching a Table

    Good Day All, I am fairly new to Access and am looking for some help. I have a table that I need to search to pull out data. The value needs to found based on salary and if it falls within a range and then all a percentage rate. I have attached some samples. Would like to see the sql...
Back
Top Bottom