Hi! I am generating a report of Supplier Statistics where I want to know how many shipments are more than 3 days late per Supplier. I have been trying to implement the DCount function to do this and it works for the Entire Report Summary, but not for the Supplier by Supplier Breakdown. I am attributing this to DCount meaning Domain Count and so it counts the entire Domain only which is my query. Is there a way to specify the domain as something like [Performance Query]![Supplier] in order to get the figures on a per Supplier basis? Or maybe there is a function I am missing that does this. Please Help! I listed my DCount control below which is working for the entire report.
=DCount("[Text86]","[Recieving Inspection Query]","[DUEDATE1] - [RECDATE1] < -3")
=DCount("[Text86]","[Recieving Inspection Query]","[DUEDATE1] - [RECDATE1] < -3")
