I have a continuous form that displays a summary of line items. I would like to be able to run a query or dcount to display how many of those line items have a specific value in one of the fields.
I have created a query that has RailcarID and UpdatedResponsibilityCode and I am trying to get it to work with a dcount.
=DCount("*","q_TestforResp7","[UpdatedResponsibilityCode] = 7 And [BillingInvoiceID]=' & Me!BillingInvoiceID'")
The query i use to test is very simple
Code:
SELECT tbl_ImportedRepairs.BillingInvoiceID, tbl_ImportedRepairs.UpdatedResponsibilityCode
FROM tbl_ImportedRepairs
WHERE (((tbl_ImportedRepairs.UpdatedResponsibilityCode)=7));
I manually set one of these fields to 7 so I could test but it still shows 0, not an error just a 0