Is there a way to do this ?

  • Thread starter Thread starter Erwin123
  • Start date Start date
E

Erwin123

Will somebody advice me on how to make a similar result in M/S Acces
using the function "lookup"( vector form ) of excel ?
Specially the functionality of lookup of Excel describe below.

=========================================
If LOOKUP can't find the lookup_value, it matches the largest value i
lookup_vector that is less than or equal to lookup_value.
=========================================

Thanks ...
 
Erwin,

I think you are looking for the DMAX function. Its format
is:

X = DMAX("fieldName", "tableName", Criteria)

To get the most recent transaction from a transaction
table, you might write a query like:

SELECT T.*
FROM Transactions T
WHERE T.TransDateTime = DMAX
("TransDateTime", "Transactions", "TransDateTime <= " & Now
())

Watch that line wrap.
 
Back
Top