I
Ian
hope someone can help. thought i knew what i was doing but....
here is a sql statment to show the appropriate records for contract. I want
the query to count the number of "rendered" services set to yes/no
I tried adding dcount("serviceid","services","rendered = -1") (for rendered)
but it counted all rendered services not just those specific to the contract
I entered.
SELECT Contracts.ContractID, [Last Name] & ", " & [First Name] AS Name,
Services.Render, Services.ServiceID
FROM (Contracts INNER JOIN Services ON Contracts.ContractID =
Services.ContractID) INNER JOIN Main ON Contracts.ClientID = Main.ClientID
GROUP BY Contracts.ContractID, [Last Name] & ", " & [First Name],
Services.Render, Services.ServiceID
HAVING (((Contracts.ContractID)=[Enter Contract ID]));
Thanks
here is a sql statment to show the appropriate records for contract. I want
the query to count the number of "rendered" services set to yes/no
I tried adding dcount("serviceid","services","rendered = -1") (for rendered)
but it counted all rendered services not just those specific to the contract
I entered.
SELECT Contracts.ContractID, [Last Name] & ", " & [First Name] AS Name,
Services.Render, Services.ServiceID
FROM (Contracts INNER JOIN Services ON Contracts.ContractID =
Services.ContractID) INNER JOIN Main ON Contracts.ClientID = Main.ClientID
GROUP BY Contracts.ContractID, [Last Name] & ", " & [First Name],
Services.Render, Services.ServiceID
HAVING (((Contracts.ContractID)=[Enter Contract ID]));
Thanks