Filter the last date only
I am trying t0 filter only the last date of the query,but i cannot
manage that.
My query is the following :
SELECT Sum([order details].liters) AS SumOfLiters, orders.invoicedate
FROM orders LEFT JOIN [order details] ON orders.orderid = [order
details].OrderID
GROUP BY orders.invoicedate;
I have tried to make a new coloumn with and
DMax("InvoiceDate","Orders")
But i have no success. This entry always disappears when i open the
query again.
Apart from the reason, is there any other way to filter and show only
the last date from the query ? |