Search results

  1. 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...
  2. 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