I am simply trying to count the number of records in a subform. I have =DCount("*","mechanicalinquired","referencenumber= " & [RererenceNumber]) and I've tried =DCount("*","mechanicalinquired","referencenumber= [RererenceNumber]") and about 100 other combinations. I get #ERROR# or #Name? in the field. Referencenumber is a number field. The dcount field is an unbound field (Text64), my table name is MechanicalInquired. What am I missing please??
Thank you in advance!