lookup, Dlookup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have form with a sum on it, I need a way to lookup up a table with the
finale amount, ex- I have amount of $1009.56, this is to lookup a table 1009
and return the $241.00, I have done it in excel but now need it to work in
access, I though this would be the way but I'm getting a name error
=DLookUp( [Text56] ,Tax_Sheet![Pay Amount],Tax_Sheet![Tax With Loading]),
I'm hoping that I can get this to work.

Thanks for any help that will get this to work
 
I have form with a sum on it, I need a way to lookup up a table with the
finale amount, ex- I have amount of $1009.56, this is to lookup a table 1009
and return the $241.00, I have done it in excel but now need it to work in
access, I though this would be the way but I'm getting a name error
=DLookUp( [Text56] ,Tax_Sheet![Pay Amount],Tax_Sheet![Tax With Loading]),
I'm hoping that I can get this to work.

Thanks for any help that will get this to work
Click to expand...

Each argument in the DLookUp must be a string.
However, your example is not clear as to what the table name is nor
what the criteria field is nor what the criteria field datatype is.

If the criteria field is a number datatype:
=DLookUp("[FieldName]","TableName","[CriteriaField] = " &
[ControlOnFormName])

If the criteria field is a Text datatype:
=DLookUp("[FieldName]","TableName","[CriteriaField] = '" &
[ControlOnFormName] & "'")

Make sure the name of this control is not the same as the name of any
field in it's control source.
 
Back
Top