HardWorking
New member
- Local time
- Today, 04:02
- Joined
- Apr 13, 2020
- Messages
- 8
Yesterday I got help with a sub query I was having a lot of trouble with and it works great using two queries.Today I would like to
combine the 2 queries into one. I have tried several things but I keep getting something wrong. Can someone
please show me what I am doing wrong? Thank you very much.
Yesterday's two final queries that work great:
qryMaxDates=
Code Tags Added by UG
Please use Code Tags when posting VBA Code
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
Today's combined query that I get an error in:
Syntax error in join operation.
combine the 2 queries into one. I have tried several things but I keep getting something wrong. Can someone
please show me what I am doing wrong? Thank you very much.
Yesterday's two final queries that work great:
qryMaxDates=
Code Tags Added by UG
Please use Code Tags when posting VBA Code
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
Code:
SELECT Max(Orders.OrderDate) AS MaxO, CustomerID
FROM Orders
GROUP BY Orders.CustomerID;
SELECT Orders.*
FROM Orders INNER JOIN qryMaxDates ON (Orders.OrderDate = qryMaxDates.MaxO) AND (Orders.CustomerID = qryMaxDates.CustomerID);
Today's combined query that I get an error in:
Syntax error in join operation.
Code:
SELECT Orders.*
FROM Orders INNER JOIN Orders.OrderDate ON t2.MaxO And Orders.CustomerID ON t2.CustomerID
(
SELECT Max(t2.OrderDate) as MaxO, t2.CustomerID
FROM Orders t2
GROUP BY t2.CustomerID
)
Last edited by a moderator: