I have 1 Text Box on a Form called Pharmacy Info. I am trying to count how many occurances of a field in a table called [Main] and a column called [Pharmacy NPI Number] that match what record the form is currently on. The field on the form that I am trying to match is in a table called [Feedback], column is [NPI_Number]
=DCount("ClaimCount","[Feedback]","[Main]![Pharmacy NPI Number] = [Feedback]![NPI_Number]")
Any help would be great. I have been stuck on this for days. I would also like to get a percentage on a seperate text box if possible.
=DCount("ClaimCount","[Feedback]","[Main]![Pharmacy NPI Number] = [Feedback]![NPI_Number]")
Any help would be great. I have been stuck on this for days. I would also like to get a percentage on a seperate text box if possible.