467,133 Members | 1,185 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,133 developers. It's quick & easy.

filtering the last date

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
  • viewed: 1874
Share:
1 Reply
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Nathan Bloomfield | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.