d lookup

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

I have two tables. One with Salary Particulars, a field name Gross.
Another table named Income Tax, with fields PayRangeLow and PayRangeHigh, and
TaxAmount.
In a query I have a column with Tax: DLookUp("TaxAmount","IncomeTax",[Gross]
& " Between [PayRangeLow] And [PayRangeHigh]") in the field section. I want
to return the tax amount payable from the Income Tax Table, based on the
Gross amount in the Salaries Register Table. It does not work. Can I
please get some help. I wold need details as to what should be in the other
fields on the query, table, criteria etc. Thanks
 
Your table name Income Tax contains a space and your DLookUp() doesn't. Are
all the fields in this table numeric?

Duane Hookom
MS Access MVP
 
Back
Top