d lookup

[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

 

[Duane Hookom]

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

 

[Jeanette Cunningham]

Hi Christina,
here are examples and discussion about getting a value from a table.
http://allenbrowne.com/casu-07.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia