Calculating variable income tax

[btillett]

Hi all,



I am trying to calculate variable income tax but can't seem to get it to work.

I have a query called payslips which calculates gross income based on hrs worked and payrate. I then have a separate tax table called TaxThreshWitheld which states the earnings and the tax witheld. I am trying to create a query that selects the tax witheld when earning from the taxwitheld table equals the gross field from the payslip query. Any suggestions. The two tables aren't linked and I am not sure how to link them. I tried to link "earnings" and "gross" but that causes the query not to run

Any suggestions

Bree

[June7]

The taxwitheld table has every amount between 0 and what? Gross pay calculation will be rounded to 2 decimals?

If you want to provide db for analysis follow instructions at bottom of my post.