I have a master table and a related subtable. I am running a report based on the master table only.
If a record appears on the subtable, I would like to put an * by the record in the report.
can you help me out with the sql? I tried
=IIf(Nz(DCount("[MasterProject]","PastProjects"),1)>1,"","*") but I think I am using the wrong formula.