By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,101 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,101 IT Pros & Developers. It's quick & easy.

filtering the last date

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.