filtering the last date

samotek

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 ?

Nov 13 '05 #1

pietlinden

you're going about it wrong.

Use DMAX or a subquery to get the latest date
then use that as a criterion for your outer query.

Nov 13 '05 #2