Recent content by Umbra1

Those spaces were completely unintentional; I have no idea how that happened. :/ Thanks for letting me know! Actually, fixing those spaces seems to have fixed the issue entirely. It all works now. Thanks -- sorry for wasting your time with an error as silly as a field name mismatch. :P

I've attached the database in a zip file. I removed some fields and other reports/forms to cut it down a little. The report in question is titled Patient Medical History Report and the formula returning #Error should be readily visible. Thanks very much for the help. :)

Thanks for the reply. Unfortunately, neither of those options works. Replacing [PID] with a number and changing the code to your alternative both return #Error. :(

I'm creating a report for an imaginary "medical clinic's database" as part of a university assignment and need help with a specific formula, the intended function of which is described as follows: "Create a statistic that shows the total number of distinct drugs prescribed to a patient." Where...