Solved Get the last entered value (1 Viewer)

[zelarra821]

Goodnight.

Well, as I say in the subject, I need to get the last value from the right column (cintura). As you can see, it does not correspond to the last date entered. Until now I did it like this:

DLookup("Cintura", "T04Peso", "Fecha=#" & DMax("Fecha", "T04Peso") & "#")

But it doesn't show me any value.

How could I fix it?

Thanks!

 

[bastanu]

Actually it shows you the value for 19Feb2021 which is the latest date. If you want the latest Cintura value create a query that returns only the Not Nulls and apply your dLookup to that:
qryCinturaNotNull: "SELECT * FROM T04PESO WHERE Cintura Is Not Null;"
DLookup("Cintura", "qryCinturaNotNull", "Fecha=#" & DMax("Fecha", "qryCinturaNotNull") & "#")
Cheers,

 

[zelarra821]

OK thank you very much.

 

[arnelgp]

just add additional condition:

DLookup("Cintura", "T04Peso", "Fecha=#" & DMax("Fecha", "T04Peso", "IsNull(Cintura) = False") & "#")

 

[zelarra821]

Thank you very much @arnelgp, I like that way better, no queries required.