I
Ian
I have a crosstab query and want to show clients that have BOTH contract 1
and contract 2. Currently it shows 1 or 2. If I change the WHERE clause to
AND I get nothing. Any ideas?
PARAMETERS [Enter Contract 1] Text ( 255 ), [Enter Contract 2] Text ( 255 );
TRANSFORM First(Contracts.ContractNotes) AS FirstOfContractNotes
SELECT Contracts.ClientID, Main.[Last Name]
FROM Contracts INNER JOIN Main ON Contracts.ClientID = Main.ClientID
WHERE (((Contracts.Contract)=[Enter Contract 1] Or
(Contracts.Contract)=[Enter Contract 2]))
GROUP BY Contracts.ClientID, Main.[Last Name]
PIVOT Contracts.Contract;
and contract 2. Currently it shows 1 or 2. If I change the WHERE clause to
AND I get nothing. Any ideas?
PARAMETERS [Enter Contract 1] Text ( 255 ), [Enter Contract 2] Text ( 255 );
TRANSFORM First(Contracts.ContractNotes) AS FirstOfContractNotes
SELECT Contracts.ClientID, Main.[Last Name]
FROM Contracts INNER JOIN Main ON Contracts.ClientID = Main.ClientID
WHERE (((Contracts.Contract)=[Enter Contract 1] Or
(Contracts.Contract)=[Enter Contract 2]))
GROUP BY Contracts.ClientID, Main.[Last Name]
PIVOT Contracts.Contract;