R
Richard
I got an crosstab query that shows all stores based with how many items a
store bought based on a where artikel id = 'ddds'
If an store didnt bought any of the article it wont show up because of the
where clause. How kan I overcome this problem?
If read something about an join but I cant make any sense of it.
Can someone help me on this?
code:
TRANSFORM Sum(dbo_SalesQuery.aantbest) AS SumOfaantbest
SELECT dbo_SalesQuery.Klant, Sum(dbo_SalesQuery.aantbest) AS Totaal
FROM dbo_SalesQuery
WHERE (( dbo_SalesQuery.Artikel Like "%124507%" )
GROUP BY dbo_SalesQuery.Klant PIVOT dbo_SalesQuery.Artikel;
Thanks in advance, Richard
store bought based on a where artikel id = 'ddds'
If an store didnt bought any of the article it wont show up because of the
where clause. How kan I overcome this problem?
If read something about an join but I cant make any sense of it.
Can someone help me on this?
code:
TRANSFORM Sum(dbo_SalesQuery.aantbest) AS SumOfaantbest
SELECT dbo_SalesQuery.Klant, Sum(dbo_SalesQuery.aantbest) AS Totaal
FROM dbo_SalesQuery
WHERE (( dbo_SalesQuery.Artikel Like "%124507%" )
GROUP BY dbo_SalesQuery.Klant PIVOT dbo_SalesQuery.Artikel;
Thanks in advance, Richard