I have a table ex. “money” and another table “taxes”,
in a table taxes the data are in ranges for ex. on field has less than 50$ the tax is 5%, or if it is less than 500$ the tax is 10%.
How can i compare the table money if i have the value in range <50$ or <500 to set the deduction for taxes.
Just set a filter on tax amounts greater than your amount.
If your amount is $450 finding the first record greater than that would get you the 500 record.
Or are you talking a tax bracket like the US uses? Where, in your case, the first $50 is taxed at 5%, and the next $450 is taxed at 10%?
Thank you. The filter was the solution. I just did it what you said and that works.