Hi Guys,
I'm new to Microsoft access and am rock stuck at a formula. Would really appreciate your help.
=DCount("ACTIONS.[ID]","[ACTIONS]","[ACTIONS].T1000ID = " & [ID] AND [ACTIONS].[% COMPLETE] > 0.6)
I have also tried =DCount("ACTIONS.[ID]","[ACTIONS]","[ACTIONS].T1000ID = " & [ID] AND "[ACTIONS].[% COMPLETE] > 0.6") however I do not get the results I am looking for.
Basically I would like a count of ACTION IDs for two AND Conditions
1. The T1000ID is equal to ID
2. % Completion is > 0.6
Any assistance is really appreciated. This is driving me crazy
Thanks
Hamza
Would you be able to recommend a resource (website/youtube) or book where I can learn the Syntax to avoid having problems in the future?
Thanks