AnsweredAssumed Answered

Check if a a value is between two number (the numbers being each in a different field)

Question asked by boyanboyan87 on Dec 3, 2018
Latest reply on Dec 3, 2018 by comment

Hi guys!


I have a question to which I am not sure how simple or complicated the solution will be.


I have a table that contains several fields. Two of these fields are "SalesFrom" and "SalesTo" with several other fields.


I have another table that contains a fields called "Sales". I need to see what record the current sales value corresponds to (i.e. Sales $1541.15 is between 1401 and 1600. So I need to go to this record and return the value in the field "TotalHours_c").


I just can't get my head around how to check to which record should be looked up depending on the value in Sales.


I hope my question makes sense.


Kind regards,