Dear access forums,
I'm in a very high level of emergency. I have to finish a report system for tomorrow, and yet, just after beginning it, I've ran into a problem.
I have something a bit similar to:
------------------
Table 1: Shops /
----------------
- ID
- Name
- Type
------------------
------------------
Table 2: Trades /
-----------------
- ID
- Date
- Shop_ID
- Amount (currency)
------------------
I want to make a query, that takes data from both tables, lists all Shops even ones without any trades in the given month.
And well, that's what doesn't work: I want to only sum trades from a given month. I'm using an outer join for that:
Code:
SELECT Shops.Name
FROM Shops LEFT JOIN Trades ON Shops.ID = Trades.Shop_ID AND
ON Trades.Date=[When?]
ORDER BY Shops.name;
But that doesn't seem to work. It keeps telling me:
Syntax error (missing operator) in query expression ".
Thank you very much for your help in advance!