Find a value in a different column

  • Thread starter Thread starter Edson
  • Start date Start date
E

Edson

Imagine the following report :
Min Weight: 86,60 On :VALUE TO BE FOUND in a data base below:
Day Weight

10/05/08 94,4
15/09/08 86,6
25/09/08 93,0

How could I do it ?
Thanks - You´re great
 
DLookup( "Day", "TableNameHere", "ABS( Weight - 86.6) < 1E-5" )


Note that I used the dot, not the coma, as decimal delimiter. Also, floating
point values are not 'precise', so I add a test with a 'precision' of 1E-5.

It should be as easy if not easier and faster to use a query and a join, if
you look for more than a single value.



Vanderghast, Access MVP
 
I'm confused. You're asking to find a value in a different column but you're
saying this is a report. The incongruity suggests that you're working with a
form or a query (or possibly a como or listbox). What specifically are you
working with?
 
Back
Top