last

[Wim]

Hi all,

I have to find values in a table/query where only the last
InputDate is "OK", all the other ones being valid no more.

How do I get these ?

e.g. query :

Id
Name
Price
InputDate

For the same Id I can have a price input on jan 01, 2001;
feb 01, 2002; and jan 01, 2003. I only want to pick the
price that is valid now.

Thanks,

Wim

 

[Guest]

Try using either the "Last" or "Max" function in the query
grid. The totals view must be selected for these options
to be available.