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,

Boyan

Outcomes